APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PER_PERIODS_OF_SERVICE

Line 1285: per_periods_of_service pps

1281: paf.hourly_salaried_code
1282: FROM per_assignments_f paf,
1283: per_all_people_f ppf,
1284: per_all_people_f ppf1,
1285: per_periods_of_service pps
1286: WHERE paf.person_id = ppf.person_id
1287: AND paf.assignment_id = cp_assignment_id
1288: AND ppf1.person_id = ppf.person_id
1289: AND ((ppf1.current_employee_flag = 'Y'

Line 1301: FROM per_periods_of_service pps1

1297: AND cp_date_earned BETWEEN ppf.effective_start_date
1298: AND ppf.effective_end_date
1299: AND pps.person_id = ppf.person_id
1300: AND pps.date_start = (SELECT MAX(pps1.date_start)
1301: FROM per_periods_of_service pps1
1302: WHERE pps1.person_id = paf.person_id
1303: AND pps1.date_start <= cp_date_earned);
1304:
1305: CURSOR c_period_details (cp_time_period_id NUMBER)