APPS.HR_ASSIGNMENT dependencies on PER_PERIODS_OF_PLACEMENT

Line 755: FROM per_periods_of_placement pdp

751: WHERE period_of_service_id = p_period_of_service_id
752: UNION
753: SELECT pdp.actual_termination_date
754: ,NVL(pdp.final_process_date, hr_api.g_eot)
755: FROM per_periods_of_placement pdp
756: WHERE pdp.person_id = l_person_id
757: AND pdp.date_start = l_pdp_date_start;
758:
759:

Line 1430: FROM per_periods_of_placement pdp

1426: WHERE period_of_service_id = p_period_of_service_id
1427: UNION
1428: SELECT NVL(pdp.actual_termination_date,to_date('30/12/4712','DD/MM/YYYY'))
1429: ,NVL(pdp.final_process_date,to_date('31/12/4712','DD/MM/YYYY'))
1430: FROM per_periods_of_placement pdp
1431: WHERE pdp.person_id = l_person_id
1432: AND pdp.date_start = l_pdp_date_start;
1433:
1434: --

Line 2166: FROM per_periods_of_placement pdp

2162: WHERE period_of_service_id = p_period_of_service_id
2163: UNION
2164: SELECT NVL(pdp.actual_termination_date, hr_api.g_eot)
2165: ,NVL(pdp.final_process_date, hr_api.g_eot)
2166: FROM per_periods_of_placement pdp
2167: WHERE pdp.person_id = l_person_id
2168: AND pdp.date_start = l_pdp_date_start;
2169:
2170: --

Line 4477: FROM per_periods_of_placement pdp

4473: AND fnd_date.canonical_to_date(p_new_date) BETWEEN
4474: p.date_start AND NVL(p.final_process_date, hr_api.g_eot)
4475: UNION
4476: SELECT pdp.date_start date_start, pdp.period_of_placement_id
4477: FROM per_periods_of_placement pdp
4478: WHERE pdp.person_id = to_number(p_person_id)
4479: AND fnd_date.canonical_to_date(p_new_date) BETWEEN
4480: pdp.date_start AND NVL(pdp.final_process_date, hr_api.g_eot)
4481: ORDER BY date_start DESC;