APPS.PAY_SE_TRNA_ARCHIVE dependencies on PER_PREVIOUS_EMPLOYERS_V

Line 462: FROM per_previous_employers_v ppev

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