DBA Data[Home] [Help]

APPS.HR_HRHD_INITIAL_LOAD dependencies on PER_PERIODS_OF_SERVICE

Line 449: per_periods_of_service pos,

445: when (pas.person_id = pop.person_id and pas.effective_end_date = pop.actual_termination_date) then to_char(pop.ACTUAL_TERMINATION_DATE,'YYYY-MM-DD') end
446:
447: FROM
448: per_all_assignments_f pas,
449: per_periods_of_service pos,
450: per_periods_of_placement pop
451: WHERE pas.person_id = pop.person_id (+)
452: AND pas.person_id = pos.person_id (+)
453: order by pas.business_group_id,pas.assignment_id,pas.effective_start_date;