APPS.PER_MX_SSAFFL_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 942: from per_assignment_extra_info pae

938: ,cp_gre_id in number
939: )
940: is
941: select aei_information3
942: from per_assignment_extra_info pae
943: where pae.assignment_id = cp_assignment_id
944: and information_type = 'MX_SS_EMP_TRANS_REASON'
945: and fnd_date.canonical_to_date(aei_information1) = cp_effective_date
946: and aei_information2 = cp_gre_id ;