APPS.PQP_CAR_MILEAGE_FUNCTIONS dependencies on PER_PERIODS_OF_SERVICE

Line 2512: FROM per_periods_of_service pds

2508:
2509: CURSOR c_get_term_date
2510: IS
2511: SELECT DECODE(NVL(TO_CHAR(pds.actual_termination_date), 'N'), 'N', 'N', 'Y') term_date
2512: FROM per_periods_of_service pds
2513: ,per_assignments_f pas
2514: WHERE pds.actual_termination_date <= p_date_earned
2515: AND pds.period_of_service_id = pas.period_of_service_id
2516: AND p_date_earned BETWEEN pas.effective_start_date