APPS.PQP_NL_PENSION_EXTRACTS dependencies on PER_ALL_PEOPLE_F

Line 122: ,ee_num per_all_people_f.employee_number%TYPE

118: ,date_start DATE
119: ,termination_date DATE
120: ,payroll_id pay_payrolls_f.payroll_id%TYPE
121: ,abp_er_num VARCHAR2(10)
122: ,ee_num per_all_people_f.employee_number%TYPE
123: ,asg_seq_num per_all_assignments_f.assignment_sequence%TYPE
124: ,ni_num per_all_people_f.national_identifier%TYPE
125: ,per_ln per_all_people_f.last_name%TYPE
126: ,per_initials per_all_people_f.per_information1%TYPE

Line 124: ,ni_num per_all_people_f.national_identifier%TYPE

120: ,payroll_id pay_payrolls_f.payroll_id%TYPE
121: ,abp_er_num VARCHAR2(10)
122: ,ee_num per_all_people_f.employee_number%TYPE
123: ,asg_seq_num per_all_assignments_f.assignment_sequence%TYPE
124: ,ni_num per_all_people_f.national_identifier%TYPE
125: ,per_ln per_all_people_f.last_name%TYPE
126: ,per_initials per_all_people_f.per_information1%TYPE
127: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE
128: ,gender per_all_people_f.sex%TYPE

Line 125: ,per_ln per_all_people_f.last_name%TYPE

121: ,abp_er_num VARCHAR2(10)
122: ,ee_num per_all_people_f.employee_number%TYPE
123: ,asg_seq_num per_all_assignments_f.assignment_sequence%TYPE
124: ,ni_num per_all_people_f.national_identifier%TYPE
125: ,per_ln per_all_people_f.last_name%TYPE
126: ,per_initials per_all_people_f.per_information1%TYPE
127: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE
128: ,gender per_all_people_f.sex%TYPE
129: ,dob per_all_people_f.date_of_birth%TYPE

Line 126: ,per_initials per_all_people_f.per_information1%TYPE

122: ,ee_num per_all_people_f.employee_number%TYPE
123: ,asg_seq_num per_all_assignments_f.assignment_sequence%TYPE
124: ,ni_num per_all_people_f.national_identifier%TYPE
125: ,per_ln per_all_people_f.last_name%TYPE
126: ,per_initials per_all_people_f.per_information1%TYPE
127: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE
128: ,gender per_all_people_f.sex%TYPE
129: ,dob per_all_people_f.date_of_birth%TYPE
130: ,partner_last_name per_all_people_f.last_name%TYPE

Line 127: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE

123: ,asg_seq_num per_all_assignments_f.assignment_sequence%TYPE
124: ,ni_num per_all_people_f.national_identifier%TYPE
125: ,per_ln per_all_people_f.last_name%TYPE
126: ,per_initials per_all_people_f.per_information1%TYPE
127: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE
128: ,gender per_all_people_f.sex%TYPE
129: ,dob per_all_people_f.date_of_birth%TYPE
130: ,partner_last_name per_all_people_f.last_name%TYPE
131: ,partner_prefix per_all_people_f.pre_name_adjunct%TYPE

Line 128: ,gender per_all_people_f.sex%TYPE

124: ,ni_num per_all_people_f.national_identifier%TYPE
125: ,per_ln per_all_people_f.last_name%TYPE
126: ,per_initials per_all_people_f.per_information1%TYPE
127: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE
128: ,gender per_all_people_f.sex%TYPE
129: ,dob per_all_people_f.date_of_birth%TYPE
130: ,partner_last_name per_all_people_f.last_name%TYPE
131: ,partner_prefix per_all_people_f.pre_name_adjunct%TYPE
132: ,address_fem_ee per_all_people_f.per_information14%TYPE

Line 129: ,dob per_all_people_f.date_of_birth%TYPE

125: ,per_ln per_all_people_f.last_name%TYPE
126: ,per_initials per_all_people_f.per_information1%TYPE
127: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE
128: ,gender per_all_people_f.sex%TYPE
129: ,dob per_all_people_f.date_of_birth%TYPE
130: ,partner_last_name per_all_people_f.last_name%TYPE
131: ,partner_prefix per_all_people_f.pre_name_adjunct%TYPE
132: ,address_fem_ee per_all_people_f.per_information14%TYPE
133: ,marital_status per_all_people_f.marital_status%TYPE

Line 130: ,partner_last_name per_all_people_f.last_name%TYPE

126: ,per_initials per_all_people_f.per_information1%TYPE
127: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE
128: ,gender per_all_people_f.sex%TYPE
129: ,dob per_all_people_f.date_of_birth%TYPE
130: ,partner_last_name per_all_people_f.last_name%TYPE
131: ,partner_prefix per_all_people_f.pre_name_adjunct%TYPE
132: ,address_fem_ee per_all_people_f.per_information14%TYPE
133: ,marital_status per_all_people_f.marital_status%TYPE
134: ,primary_flag per_all_assignments_f.primary_flag%TYPE

Line 131: ,partner_prefix per_all_people_f.pre_name_adjunct%TYPE

127: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE
128: ,gender per_all_people_f.sex%TYPE
129: ,dob per_all_people_f.date_of_birth%TYPE
130: ,partner_last_name per_all_people_f.last_name%TYPE
131: ,partner_prefix per_all_people_f.pre_name_adjunct%TYPE
132: ,address_fem_ee per_all_people_f.per_information14%TYPE
133: ,marital_status per_all_people_f.marital_status%TYPE
134: ,primary_flag per_all_assignments_f.primary_flag%TYPE
135: );

Line 132: ,address_fem_ee per_all_people_f.per_information14%TYPE

128: ,gender per_all_people_f.sex%TYPE
129: ,dob per_all_people_f.date_of_birth%TYPE
130: ,partner_last_name per_all_people_f.last_name%TYPE
131: ,partner_prefix per_all_people_f.pre_name_adjunct%TYPE
132: ,address_fem_ee per_all_people_f.per_information14%TYPE
133: ,marital_status per_all_people_f.marital_status%TYPE
134: ,primary_flag per_all_assignments_f.primary_flag%TYPE
135: );
136:

Line 133: ,marital_status per_all_people_f.marital_status%TYPE

129: ,dob per_all_people_f.date_of_birth%TYPE
130: ,partner_last_name per_all_people_f.last_name%TYPE
131: ,partner_prefix per_all_people_f.pre_name_adjunct%TYPE
132: ,address_fem_ee per_all_people_f.per_information14%TYPE
133: ,marital_status per_all_people_f.marital_status%TYPE
134: ,primary_flag per_all_assignments_f.primary_flag%TYPE
135: );
136:
137: TYPE t_assig_details IS TABLE OF assig_details INDEX BY BINARY_INTEGER;