APPS.HR_ASSIGNMENT dependencies on PER_PERIODS_OF_PLACEMENT

Line 785: FROM per_periods_of_placement pdp

781: WHERE period_of_service_id = p_period_of_service_id
782: UNION
783: SELECT pdp.actual_termination_date
784: ,NVL(pdp.final_process_date, hr_api.g_eot)
785: FROM per_periods_of_placement pdp
786: WHERE pdp.person_id = l_person_id
787: AND pdp.date_start = l_pdp_date_start;
788:
789:

Line 1460: FROM per_periods_of_placement pdp

1456: WHERE period_of_service_id = p_period_of_service_id
1457: UNION
1458: SELECT NVL(pdp.actual_termination_date,to_date('30/12/4712','DD/MM/YYYY'))
1459: ,NVL(pdp.final_process_date,to_date('31/12/4712','DD/MM/YYYY'))
1460: FROM per_periods_of_placement pdp
1461: WHERE pdp.person_id = l_person_id
1462: AND pdp.date_start = l_pdp_date_start;
1463:
1464: --

Line 2203: FROM per_periods_of_placement pdp

2199: WHERE period_of_service_id = p_period_of_service_id
2200: UNION
2201: SELECT NVL(pdp.actual_termination_date, hr_api.g_eot)
2202: ,NVL(pdp.final_process_date, hr_api.g_eot)
2203: FROM per_periods_of_placement pdp
2204: WHERE pdp.person_id = l_person_id
2205: AND pdp.date_start = l_pdp_date_start;
2206:
2207: --

Line 4517: FROM per_periods_of_placement pdp

4513: AND fnd_date.canonical_to_date(p_new_date) BETWEEN
4514: p.date_start AND NVL(p.final_process_date, hr_api.g_eot)
4515: UNION
4516: SELECT pdp.date_start date_start, pdp.period_of_placement_id
4517: FROM per_periods_of_placement pdp
4518: WHERE pdp.person_id = to_number(p_person_id)
4519: AND fnd_date.canonical_to_date(p_new_date) BETWEEN
4520: pdp.date_start AND NVL(pdp.final_process_date, hr_api.g_eot)
4521: ORDER BY date_start DESC;