APPS.HRI_OPL_SUP_STATUS_HST dependencies on PER_PERIODS_OF_PLACEMENT

Line 283: from per_periods_of_placement

279: UNION ALL
280: select person_id,
281: date_start,
282: actual_termination_date
283: from per_periods_of_placement
284: )pos,
285: (--
286: -- This gets all supervisors whose subordinates have had events that
287: -- can affects his supervisory status

Line 357: FROM per_periods_of_placement pop

353: --
354: UNION
355: SELECT pop.person_id,
356: GREATEST(p_collect_from,pop.date_start)
357: FROM per_periods_of_placement pop
358: WHERE (p_collect_from BETWEEN pop.date_start AND NVL(pop.actual_termination_date, hr_general.end_of_time)
359: OR p_collect_from <= pop.date_start)
360: )leaf_date
361: WHERE leaf_date.event_supervisor_id = asg.supervisor_id (+)

Line 513: from per_periods_of_placement pop,

509: UNION ALL
510: select pop.person_id,
511: pop.date_start,
512: pop.actual_termination_date
513: from per_periods_of_placement pop,
514: hri_eq_sprvsr_hstry_chgs eq
515: WHERE eq.person_id=pop.person_id
516: )pos,
517: (--

Line 595: FROM per_periods_of_placement pop,

591: --
592: SELECT pop.person_id,
593: GREATEST(hri_bpl_parameter.get_bis_global_start_date
594: ,pop.date_start)
595: FROM per_periods_of_placement pop,
596: hri_eq_sprvsr_hstry_chgs eq
597: WHERE eq.person_id=pop.person_id
598: ) leaf_date
599: WHERE leaf_date.event_supervisor_id = asg.supervisor_id (+)

Line 758: from per_periods_of_placement

754: UNION ALL
755: select person_id,
756: date_start,
757: actual_termination_date
758: from per_periods_of_placement
759: )pos,
760: (--
761: -- This gets all supervisors whose subordinates have had events that
762: -- can affects his supervisory status

Line 799: FROM per_periods_of_placement pop

795: -- Gets all active contingent workers
796: --
797: UNION
798: SELECT pop.person_id, GREATEST(p_collect_from,pop.date_start)
799: FROM per_periods_of_placement pop
800: WHERE (p_collect_from BETWEEN pop.date_start
801: AND NVL(pop.actual_termination_date, hr_general.end_of_time)
802: OR p_collect_from <= pop.date_start)
803: )leaf_date

Line 959: from per_periods_of_placement pop,

955: UNION ALL
956: select pop.person_id,
957: pop.date_start,
958: pop.actual_termination_date
959: from per_periods_of_placement pop,
960: hri_eq_sprvsr_hstry_chgs eq
961: WHERE eq.person_id=pop.person_id
962: )pos,
963: (--

Line 1009: FROM per_periods_of_placement pop,

1005: --
1006: SELECT pop.person_id,
1007: GREATEST(hri_bpl_parameter.get_bis_global_start_date
1008: ,pop.date_start)
1009: FROM per_periods_of_placement pop,
1010: hri_eq_sprvsr_hstry_chgs eq
1011: WHERE eq.person_id=pop.person_id
1012: ) leaf_date
1013: WHERE leaf_date.event_supervisor_id = asg.supervisor_id (+)

Line 1182: ,per_periods_of_placement ppp

1178: (SELECT
1179: ppp.person_id
1180: FROM
1181: hri_eq_sprvsr_hstry_chgs eq2
1182: ,per_periods_of_placement ppp
1183: WHERE eq2.person_id = ppp.person_id
1184: AND ppp.date_start <> eq2.erlst_evnt_effective_date
1185: AND ppp.actual_termination_date IS NULL);
1186: --