APPS.HRI_EDW_FCT_WRKFC_SPRTN dependencies on PER_PERIODS_OF_SERVICE

Line 287: FROM per_periods_of_service pos

283: pos.actual_termination_date)
284: ,DECODE(SIGN(pos.final_process_date - sysdate),
285: 1, to_date(null),
286: pos.final_process_date)
287: FROM per_periods_of_service pos
288: WHERE hps.period_of_service_id = pos.period_of_service_id);
289:
290: -- This insert should pick up all assignment/person/period of
291: -- service combinations that do not exist in the performance

Line 321: ,per_periods_of_service pps

317: 1, to_date(null),
318: pps.final_process_date)
319: FROM
320: per_all_assignments_f asg
321: ,per_periods_of_service pps
322: WHERE asg.person_id = pps.person_id
323: AND asg.period_of_service_id = pps.period_of_service_id
324: AND asg.effective_start_date =
325: (SELECT MAX(asg2.effective_start_date)