APPS.PAY_SE_ARCHIVE_TETA dependencies on PER_PREVIOUS_EMPLOYERS_V

Line 660: FROM per_previous_employers_v ppev

656: ,csr_v_business_group_id NUMBER
657: , csr_v_effective_date DATE )
658: IS
659: SELECT *
660: FROM per_previous_employers_v ppev
661: WHERE ppev.person_id= csr_v_person_id
662: AND ppev.business_group_id = csr_v_business_group_id
663: AND ppev.start_date <= csr_v_effective_date
664: ORDER BY ppev.start_date DESC;