APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 2522: FROM per_assignment_extra_info pae

2518: CURSOR c_get_leaving_reason ( cp_assignment_id IN NUMBER
2519: ,cp_effective_date IN DATE
2520: ,cp_gre_id IN NUMBER ) IS
2521: SELECT aei_information3
2522: FROM per_assignment_extra_info pae
2523: WHERE pae.assignment_id = cp_assignment_id
2524: AND information_type = 'MX_SS_EMP_TRANS_REASON'
2525: AND fnd_date.canonical_to_date(aei_information1) = cp_effective_date
2526: AND aei_information2 = cp_gre_id ;