+- Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities (http://www.oraerp.com)
+-- Forum: Oracle Applications (http://www.oraerp.com/forum-39.html)
+--- Forum: Oracle E-Business Suite (EBS) (http://www.oraerp.com/forum-1.html)
+---- Forum: Human Resources (http://www.oraerp.com/forum-4.html)
+---- Thread: Queries for HRMS Hirecount,Termination Count,Head Count (/thread-70944.html)
Queries for HRMS Hirecount,Termination Count,Head Count - Kumar123 - 02-21-2013
Can anyone please provide queries for hirecount ,Termination Count,head Count in HRMS.
Thanks in advance.
RE: Queries for HRMS Hirecount,Termination Count,Head Count - Richard - 02-22-2013
1. Employee joined between two dates
select
b.full_name,
b.applicant_number,
a.current_employer,
d.name job,
e.date_start Actual_DOJ,
b.business_group_id
from
per_applications a,
per_all_people_f b,
per_all_assignments_f c,
per_jobs d,
per_periods_of_service e
where 1=1
and a.person_id(+) = b.person_id
and b.person_id = c.person_id
and trunc(sysdate) between b.effective_start_date and b.effective_end_date
and trunc(sysdate) between c.effective_start_date and c.effective_end_date
and C.JOB_ID = D.JOB_ID(+)
and E.PERSON_ID = B.PERSON_ID
and e.date_start between to_date('01-JAN-2013','DD-MON-YYYY') and to_date('31-JAN-2013','DD-MON-YYYY')
2. Employees left between two dates
select
b.full_name,
b.applicant_number,
a.current_employer,
d.name job,
e.date_start Actual_DOJ,
b.business_group_id
from
per_applications a,
per_all_people_f b,
per_all_assignments_f c,
per_jobs d,
per_periods_of_service e
where 1=1
and a.person_id(+) = b.person_id
and b.person_id = c.person_id
and trunc(sysdate) between b.effective_start_date and b.effective_end_date
and trunc(sysdate) between c.effective_start_date and c.effective_end_date
and C.JOB_ID = D.JOB_ID(+)
and E.PERSON_ID = B.PERSON_ID
and e.date_start between to_date('01-JAN-2013','DD-MON-YYYY') and to_date('31-JAN-2013','DD-MON-YYYY')
RE: Queries for HRMS Hirecount,Termination Count,Head Count - suri1989 - 09-12-2013
Good Post........Keep it Up Good Work.
Regards,
Surendra