DBA Data[Home] [Help]

APPS.HR_HEAD_COUNT dependencies on PER_PERIODS_OF_PLACEMENT

Line 628: from per_periods_of_placement pop

624: select pop.termination_reason
625: ,pop.actual_termination_date
626: ,paf.job_id
627: ,paf.assignment_id
628: from per_periods_of_placement pop
629: ,per_all_assignments_f paf
630: where pop.date_start <= P_DATE_FROM
631: and pop.actual_termination_date is not null
632: and pop.actual_termination_date between P_DATE_FROM

Line 654: from per_periods_of_placement pop

650: select pop.termination_reason
651: ,pop.actual_termination_date
652: ,paf.job_id
653: ,paf.assignment_id
654: from per_periods_of_placement pop
655: ,per_all_assignments_f paf
656: where pop.date_start <= P_DATE_FROM
657: and pop.actual_termination_date is not null
658: and pop.actual_termination_date between P_CUR_DATE_FROM