APPS.HR_ASSIGNMENT dependencies on PER_PERIODS_OF_SERVICE

Line 780: FROM per_periods_of_service

776: --
777: CURSOR csr_get_term_dates IS
778: SELECT actual_termination_date
779: ,NVL(final_process_date, hr_api.g_eot)
780: FROM per_periods_of_service
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)

Line 1278: from per_periods_of_service

1274: hr_utility.set_location('hr_assignment.get_act_term_date',1);
1275: --
1276: select actual_termination_date
1277: into p_actual_termination_date
1278: from per_periods_of_service
1279: where period_of_service_id = p_period_of_service_id;
1280: --
1281: END get_act_term_date;
1282: --

Line 1455: FROM per_periods_of_service

1451:
1452: CURSOR csr_get_term_dates IS
1453: SELECT NVL(actual_termination_date, to_date('30/12/4712','DD/MM/YYYY'))
1454: ,NVL(final_process_date,to_date('31/12/4712','DD/MM/YYYY'))
1455: FROM per_periods_of_service
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'))

Line 2198: FROM per_periods_of_service

2194: --
2195: CURSOR csr_get_term_dates IS
2196: SELECT NVL(actual_termination_date, hr_api.g_eot)
2197: ,NVL(final_process_date, hr_api.g_eot)
2198: FROM per_periods_of_service
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)

Line 4511: FROM per_periods_of_service p

4507: l_pos_id NUMBER;
4508:
4509: CURSOR get_pos IS
4510: SELECT p.date_start date_start, p.period_of_service_id
4511: FROM per_periods_of_service p
4512: WHERE p.person_id = to_number(p_person_id)
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