APPS.HRI_OPL_SUP_STATUS_HST dependencies on PER_PERIODS_OF_SERVICE

Line 278: from per_periods_of_service

274: per_assignment_status_types ast,
275: (select person_id,
276: date_start,
277: actual_termination_date
278: from per_periods_of_service
279: UNION ALL
280: select person_id,
281: date_start,
282: actual_termination_date

Line 348: FROM per_periods_of_service pos

344: -- Gets all active person's
345: --
346: SELECT pos.person_id,
347: GREATEST(p_collect_from,pos.date_start)
348: FROM per_periods_of_service pos
349: WHERE (p_collect_from BETWEEN pos.date_start AND NVL(pos.actual_termination_date, hr_general.end_of_time)
350: OR p_collect_from <= pos.date_start)
351: --
352: -- Gets all active contingent workers

Line 506: from per_periods_of_service pos,

502: --
503: (select pos.person_id,
504: pos.date_start,
505: pos.actual_termination_date
506: from per_periods_of_service pos,
507: hri_eq_sprvsr_hstry_chgs eq
508: where eq.person_id=pos.person_id
509: UNION ALL
510: select pop.person_id,

Line 585: FROM per_periods_of_service pos,

581: --
582: SELECT pos.person_id,
583: GREATEST(hri_bpl_parameter.get_bis_global_start_date
584: ,pos.date_start)
585: FROM per_periods_of_service pos,
586: hri_eq_sprvsr_hstry_chgs eq
587: WHERE eq.person_id=pos.person_id
588: UNION
589: --

Line 753: from per_periods_of_service

749: per_assignment_status_types ast,
750: (select person_id,
751: date_start,
752: actual_termination_date
753: from per_periods_of_service
754: UNION ALL
755: select person_id,
756: date_start,
757: actual_termination_date

Line 790: FROM per_periods_of_service pos

786: --
787: -- Gets all active employees
788: --
789: SELECT pos.person_id, GREATEST(p_collect_from,pos.date_start)
790: FROM per_periods_of_service pos
791: WHERE (p_collect_from BETWEEN pos.date_start
792: AND NVL(pos.actual_termination_date, hr_general.end_of_time)
793: OR p_collect_from <= pos.date_start)
794: --

Line 952: from per_periods_of_service pos,

948: --
949: (select pos.person_id,
950: pos.date_start,
951: pos.actual_termination_date
952: from per_periods_of_service pos,
953: hri_eq_sprvsr_hstry_chgs eq
954: where eq.person_id=pos.person_id
955: UNION ALL
956: select pop.person_id,

Line 999: FROM per_periods_of_service pos,

995: --
996: SELECT pos.person_id,
997: GREATEST(hri_bpl_parameter.get_bis_global_start_date
998: ,pos.date_start)
999: FROM per_periods_of_service pos,
1000: hri_eq_sprvsr_hstry_chgs eq
1001: WHERE eq.person_id=pos.person_id
1002: UNION
1003: --

Line 1168: ,per_periods_of_service pps

1164: (SELECT
1165: pps.person_id
1166: FROM
1167: hri_eq_sprvsr_hstry_chgs eq2
1168: ,per_periods_of_service pps
1169: WHERE eq2.person_id = pps.person_id
1170: AND pps.date_start <> eq2.erlst_evnt_effective_date
1171: AND pps.actual_termination_date IS NULL);
1172: --