APPS.PAY_SE_TRNA_ARCHIVE dependencies on PER_PREVIOUS_EMPLOYERS_V

Line 460: FROM per_previous_employers_v ppev

456: csr_v_business_group_id NUMBER,
457: csr_v_effective_date DATE
458: ) IS
459: SELECT start_date, end_date, end_date - start_date prev_emp_days
460: FROM per_previous_employers_v ppev
461: WHERE ppev.person_id = csr_v_person_id
462: AND ppev.business_group_id = csr_v_business_group_id
463: AND ppev.start_date <= csr_v_effective_date
464: ORDER BY ppev.start_date ASC;