[Home] [Help]
APPS.PER_IE_ASG_EXT_INFO dependencies on PER_ASSIGNMENT_EXTRA_INFO
Line 61: FROM per_all_assignments_f paaf, per_all_people_f papf, per_assignment_extra_info paei
57: IS
58:
59: CURSOR cur_ppsn_number IS
60: SELECT DISTINCT NATIONAL_IDENTIFIER
61: FROM per_all_assignments_f paaf, per_all_people_f papf, per_assignment_extra_info paei
62: WHERE paei.assignment_extra_info_id = p_assignment_extra_info_id
63: and paei.aei_information_category = p_aei_information_category
64: AND paaf.assignment_id = paei.assignment_id
65: AND paaf.person_id = papf.person_id;