APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 2398: FROM per_assignment_extra_info pae

2394: CURSOR c_get_leaving_reason ( cp_assignment_id IN NUMBER
2395: ,cp_effective_date IN DATE
2396: ,cp_gre_id IN NUMBER ) IS
2397: SELECT aei_information3
2398: FROM per_assignment_extra_info pae
2399: WHERE pae.assignment_id = cp_assignment_id
2400: AND information_type = 'MX_SS_EMP_TRANS_REASON'
2401: AND fnd_date.canonical_to_date(aei_information1) = cp_effective_date
2402: AND aei_information2 = cp_gre_id ;