APPS.HR_ASSIGNMENT dependencies on PER_PERIODS_OF_SERVICE

Line 750: FROM per_periods_of_service

746: --
747: CURSOR csr_get_term_dates IS
748: SELECT actual_termination_date
749: ,NVL(final_process_date, hr_api.g_eot)
750: FROM per_periods_of_service
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)

Line 1248: from per_periods_of_service

1244: hr_utility.set_location('hr_assignment.get_act_term_date',1);
1245: --
1246: select actual_termination_date
1247: into p_actual_termination_date
1248: from per_periods_of_service
1249: where period_of_service_id = p_period_of_service_id;
1250: --
1251: END get_act_term_date;
1252: --

Line 1425: FROM per_periods_of_service

1421:
1422: CURSOR csr_get_term_dates IS
1423: SELECT NVL(actual_termination_date, to_date('30/12/4712','DD/MM/YYYY'))
1424: ,NVL(final_process_date,to_date('31/12/4712','DD/MM/YYYY'))
1425: FROM per_periods_of_service
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'))

Line 2161: FROM per_periods_of_service

2157: --
2158: CURSOR csr_get_term_dates IS
2159: SELECT NVL(actual_termination_date, hr_api.g_eot)
2160: ,NVL(final_process_date, hr_api.g_eot)
2161: FROM per_periods_of_service
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)

Line 4471: FROM per_periods_of_service p

4467: l_pos_id NUMBER;
4468:
4469: CURSOR get_pos IS
4470: SELECT p.date_start date_start, p.period_of_service_id
4471: FROM per_periods_of_service p
4472: WHERE p.person_id = to_number(p_person_id)
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