tag:blogger.com,1999:blog-6375526890673207542.post6801877011551044282..comments2023-10-24T02:18:57.226+05:30Comments on Oracle Apps: HRMS- SQL Query for Extracting Employee InformationVamsi Mantripragadahttp://www.blogger.com/profile/06067977099010762847noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-6375526890673207542.post-86927125210912029702017-07-02T18:12:29.051+05:302017-07-02T18:12:29.051+05:30Can i have query department wise employees in HRMS...Can i have query department wise employees in HRMSAnonymoushttps://www.blogger.com/profile/00479192428239075824noreply@blogger.comtag:blogger.com,1999:blog-6375526890673207542.post-82242296032660228542012-10-08T09:07:01.631+05:302012-10-08T09:07:01.631+05:30Hi Vamsi,
thanks for your reply can you help me t...Hi Vamsi,<br /><br />thanks for your reply can you help me to fix the query. I try to match with your syntax and i am still missing some thing.<br /><br />SELECT ppp.proposed_salary_n salary From apps.per_pay_proposals ppp,apps.per_all_people_f papf,apps.per_all_assignments_f paaf,apps.per_all_people_f papf1 WHERE papf.person_id = paaf.person_id AND SYSDATE BETWEEN papf.effective_start_date And papf.effective_end_date AND SYSDATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date AND papf.employee_number='31284';WLS Cafehttps://www.blogger.com/profile/01517279810194640097noreply@blogger.comtag:blogger.com,1999:blog-6375526890673207542.post-44920126850352357722012-10-08T08:52:40.486+05:302012-10-08T08:52:40.486+05:30This comment has been removed by the author.WLS Cafehttps://www.blogger.com/profile/01517279810194640097noreply@blogger.comtag:blogger.com,1999:blog-6375526890673207542.post-32573136045495002742012-10-01T15:52:50.484+05:302012-10-01T15:52:50.484+05:30Hi Raj,
Please use below query..
SELECT
p.person...Hi Raj,<br /><br />Please use below query..<br /><br />SELECT<br />p.person_id<br />,p.full_name<br />,p.employee_number<br />,p.business_group_id<br />, (pp.proposed_salary_n * b.pay_annualization_factor) salary<br />,a.assignment_id<br />FROM per_all_people_f p<br />,per_all_assignments_f a<br />,per_pay_proposals pp<br />,Per_Pay_Bases B<br />WHERE p.person_id = 293884<br />And P.Person_Id = A.Person_Id<br />And Sysdate Between P.Effective_Start_Date And P.Effective_End_Date<br />and sysdate between a.effective_start_date and a.effective_end_date<br />And Pp.Assignment_Id = A.Assignment_Id<br />And A.Assignment_Id = 281336<br />And B.Pay_Basis_Id = A.Pay_Basis_Id;<br /><br />Regards,<br />VamsiVamsi Mantripragadahttps://www.blogger.com/profile/06067977099010762847noreply@blogger.comtag:blogger.com,1999:blog-6375526890673207542.post-74998343870523193952012-09-30T13:39:55.319+05:302012-09-30T13:39:55.319+05:30Hi Vamsi,
can you do me a favor ?
I am able to fi...Hi Vamsi,<br /><br />can you do me a favor ?<br />I am able to find supervisor name on HRMS using below query<br /><br />SELECT papf1.full_name supervisor_name From apps.per_all_people_f papf,apps.per_all_assignments_f paaf,apps.per_all_people_f papf1 WHERE papf.person_id = paaf.person_id AND paaf.primary_flag = 'Y' AND paaf.assignment_type = 'E' AND paaf.supervisor_id = papf1.person_id AND papf1.current_employee_flag = 'Y'AND papf.business_group_id = paaf.business_group_id AND SYSDATE BETWEEN papf.effective_start_date and papf.effective_end_date AND SYSDATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date AND SYSDATE BETWEEN papf1.effective_start_date AND papf1.effective_end_date AND papf.employee_number='23436';<br /><br /><br />and now i am trying to find employee salary (gross) on HRMS using below query...for some reason the query is not working for me can you help ?<br /><br /><br />SELECT ppp.proposed_salary_n salary From per_pay_proposals ppp,apps.per_all_people_f papf,apps.per_all_assignments_f paaf,apps.per_all_people_f papf1 WHERE papf.person_id = paaf.person_id AND paaf.primary_flag = 'Y' AND paaf.assignment_type = 'E' AND paaf.supervisor_id = papf1.person_id AND papf1.current_employee_flag = 'Y'AND papf.business_group_id = paaf.business_group_id AND SYSDATE BETWEEN papf.effective_start_date and papf.effective_end_date AND SYSDATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date AND SYSDATE BETWEEN papf1.effective_start_date AND papf1.effective_end_date AND papf.employee_number='23436';<br /><br /><br />Thanks<br />Raj<br />WLS Cafehttps://www.blogger.com/profile/01517279810194640097noreply@blogger.com