APPS.PER_GB_PENSRV_SVPN dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 66: FROM per_assignment_Extra_info

62:
63: CURSOR cur_get_eit_info(c_assignment_id NUMBER)
64: IS
65: SELECT aei_information1
66: FROM per_assignment_Extra_info
67: WHERE assignment_id = c_assignment_id
68: AND aei_information_category = 'PQP_GB_PENSERV_SVPN';
69:
70: -- Cursor to fetch maximum service period number

Line 77: per_assignment_extra_info paei

73: IS
74: SELECT max(to_number(paei.aei_information1))+1
75: FROM per_all_people_f papf,
76: per_all_assignments_f paaf,
77: per_assignment_extra_info paei
78: WHERE papf.NATIONAL_IDENTIFIER = c_ni_number
79: AND papf.person_id = paaf.person_id
80: AND paei.assignment_id = paaf.assignment_id
81: AND paei.aei_information_category = 'PQP_GB_PENSERV_SVPN';