APPS.HR_MX_UTILITY dependencies on PER_PERIODS_OF_SERVICE

Line 874: FROM per_periods_of_service pps,

870: -- Bug 4650086
871: CURSOR c_get_adj_svc_date
872: IS
873: SELECT pps.adjusted_svc_date
874: FROM per_periods_of_service pps,
875: per_all_people_f pap
876: WHERE pap.person_id = p_person_id
877: AND pps.person_id = pap.person_id
878: AND p_effective_date BETWEEN pap.effective_start_date

Line 881: FROM per_periods_of_service pps1

877: AND pps.person_id = pap.person_id
878: AND p_effective_date BETWEEN pap.effective_start_date
879: AND pap.effective_end_date
880: AND pps.date_start = (SELECT MAX (pps1.date_start)
881: FROM per_periods_of_service pps1
882: WHERE pps1.person_id = pps.person_id
883: AND pps1.date_start <= p_effective_date);
884: -- ORDER BY pps.adjusted_svc_date DESC;
885:

Line 1292: FROM per_periods_of_service pps,

1288: -- curosr to get adjusted service date
1289: CURSOR c_get_adj_svc_date
1290: IS
1291: SELECT pps.adjusted_svc_date
1292: FROM per_periods_of_service pps,
1293: per_all_assignments_f paa
1294: WHERE paa.assignment_id = p_assignment_id
1295: AND p_effective_date BETWEEN paa.effective_start_date
1296: AND paa.effective_end_date

Line 1299: FROM per_periods_of_service pps1

1295: AND p_effective_date BETWEEN paa.effective_start_date
1296: AND paa.effective_end_date
1297: AND pps.person_id = paa.person_id
1298: AND pps.date_start = (SELECT MAX (pps1.date_start)
1299: FROM per_periods_of_service pps1
1300: WHERE pps1.person_id = pps.person_id
1301: AND pps1.date_start <= p_effective_date);
1302:
1303:

Line 1322: per_periods_of_service pps

1318: CURSOR c_get_latest_hire_date
1319: IS
1320: SELECT max(pps.date_start)
1321: FROM per_all_assignments_f paa,
1322: per_periods_of_service pps
1323: WHERE paa.assignment_id = p_assignment_id
1324: AND p_effective_date BETWEEN paa.effective_start_date
1325: AND paa.effective_end_date
1326: AND pps.person_id = paa.person_id