DBA Data[Home] [Help]

APPS.HR_HEAD_COUNT dependencies on PER_PERIODS_OF_SERVICE

Line 582: from per_periods_of_service pos

578: select pos.leaving_reason
579: ,pos.actual_termination_date
580: ,paf.job_id
581: ,paf.assignment_id
582: from per_periods_of_service pos
583: ,per_all_assignments_f paf
584: where pos.date_start <= P_DATE_FROM
585: and pos.actual_termination_date is not null
586: and pos.actual_termination_date between P_DATE_FROM

Line 606: from per_periods_of_service pos

602: select pos.leaving_reason
603: ,pos.actual_termination_date
604: ,paf.job_id
605: ,paf.assignment_id
606: from per_periods_of_service pos
607: ,per_all_assignments_f paf
608: where pos.date_start <= P_DATE_FROM
609: and pos.actual_termination_date is not null
610: and pos.actual_termination_date between