APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on PER_ALL_PEOPLE_F

Line 84: ,ee_num per_all_people_f.employee_number%TYPE

80: ,date_start DATE
81: ,termination_date DATE
82: ,payroll_id pay_payrolls_f.payroll_id%TYPE
83: ,pggm_er_num VARCHAR2(10)
84: ,ee_num per_all_people_f.employee_number%TYPE
85: ,asg_seq_num per_all_assignments_f.assignment_sequence%TYPE
86: ,ni_num per_all_people_f.national_identifier%TYPE
87: ,per_ln per_all_people_f.last_name%TYPE
88: ,per_initials per_all_people_f.per_information1%TYPE

Line 86: ,ni_num per_all_people_f.national_identifier%TYPE

82: ,payroll_id pay_payrolls_f.payroll_id%TYPE
83: ,pggm_er_num VARCHAR2(10)
84: ,ee_num per_all_people_f.employee_number%TYPE
85: ,asg_seq_num per_all_assignments_f.assignment_sequence%TYPE
86: ,ni_num per_all_people_f.national_identifier%TYPE
87: ,per_ln per_all_people_f.last_name%TYPE
88: ,per_initials per_all_people_f.per_information1%TYPE
89: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE
90: ,gender per_all_people_f.sex%TYPE

Line 87: ,per_ln per_all_people_f.last_name%TYPE

83: ,pggm_er_num VARCHAR2(10)
84: ,ee_num per_all_people_f.employee_number%TYPE
85: ,asg_seq_num per_all_assignments_f.assignment_sequence%TYPE
86: ,ni_num per_all_people_f.national_identifier%TYPE
87: ,per_ln per_all_people_f.last_name%TYPE
88: ,per_initials per_all_people_f.per_information1%TYPE
89: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE
90: ,gender per_all_people_f.sex%TYPE
91: ,dob per_all_people_f.date_of_birth%TYPE

Line 88: ,per_initials per_all_people_f.per_information1%TYPE

84: ,ee_num per_all_people_f.employee_number%TYPE
85: ,asg_seq_num per_all_assignments_f.assignment_sequence%TYPE
86: ,ni_num per_all_people_f.national_identifier%TYPE
87: ,per_ln per_all_people_f.last_name%TYPE
88: ,per_initials per_all_people_f.per_information1%TYPE
89: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE
90: ,gender per_all_people_f.sex%TYPE
91: ,dob per_all_people_f.date_of_birth%TYPE
92: ,partner_last_name per_all_people_f.last_name%TYPE

Line 89: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE

85: ,asg_seq_num per_all_assignments_f.assignment_sequence%TYPE
86: ,ni_num per_all_people_f.national_identifier%TYPE
87: ,per_ln per_all_people_f.last_name%TYPE
88: ,per_initials per_all_people_f.per_information1%TYPE
89: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE
90: ,gender per_all_people_f.sex%TYPE
91: ,dob per_all_people_f.date_of_birth%TYPE
92: ,partner_last_name per_all_people_f.last_name%TYPE
93: ,partner_prefix per_all_people_f.pre_name_adjunct%TYPE

Line 90: ,gender per_all_people_f.sex%TYPE

86: ,ni_num per_all_people_f.national_identifier%TYPE
87: ,per_ln per_all_people_f.last_name%TYPE
88: ,per_initials per_all_people_f.per_information1%TYPE
89: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE
90: ,gender per_all_people_f.sex%TYPE
91: ,dob per_all_people_f.date_of_birth%TYPE
92: ,partner_last_name per_all_people_f.last_name%TYPE
93: ,partner_prefix per_all_people_f.pre_name_adjunct%TYPE
94: ,address_fem_ee per_all_people_f.per_information14%TYPE

Line 91: ,dob per_all_people_f.date_of_birth%TYPE

87: ,per_ln per_all_people_f.last_name%TYPE
88: ,per_initials per_all_people_f.per_information1%TYPE
89: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE
90: ,gender per_all_people_f.sex%TYPE
91: ,dob per_all_people_f.date_of_birth%TYPE
92: ,partner_last_name per_all_people_f.last_name%TYPE
93: ,partner_prefix per_all_people_f.pre_name_adjunct%TYPE
94: ,address_fem_ee per_all_people_f.per_information14%TYPE
95: ,marital_status per_all_people_f.marital_status%TYPE

Line 92: ,partner_last_name per_all_people_f.last_name%TYPE

88: ,per_initials per_all_people_f.per_information1%TYPE
89: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE
90: ,gender per_all_people_f.sex%TYPE
91: ,dob per_all_people_f.date_of_birth%TYPE
92: ,partner_last_name per_all_people_f.last_name%TYPE
93: ,partner_prefix per_all_people_f.pre_name_adjunct%TYPE
94: ,address_fem_ee per_all_people_f.per_information14%TYPE
95: ,marital_status per_all_people_f.marital_status%TYPE
96: ,primary_flag per_all_assignments_f.primary_flag%TYPE

Line 93: ,partner_prefix per_all_people_f.pre_name_adjunct%TYPE

89: ,per_prefix per_all_people_f.pre_name_adjunct%TYPE
90: ,gender per_all_people_f.sex%TYPE
91: ,dob per_all_people_f.date_of_birth%TYPE
92: ,partner_last_name per_all_people_f.last_name%TYPE
93: ,partner_prefix per_all_people_f.pre_name_adjunct%TYPE
94: ,address_fem_ee per_all_people_f.per_information14%TYPE
95: ,marital_status per_all_people_f.marital_status%TYPE
96: ,primary_flag per_all_assignments_f.primary_flag%TYPE
97: );

Line 94: ,address_fem_ee per_all_people_f.per_information14%TYPE

90: ,gender per_all_people_f.sex%TYPE
91: ,dob per_all_people_f.date_of_birth%TYPE
92: ,partner_last_name per_all_people_f.last_name%TYPE
93: ,partner_prefix per_all_people_f.pre_name_adjunct%TYPE
94: ,address_fem_ee per_all_people_f.per_information14%TYPE
95: ,marital_status per_all_people_f.marital_status%TYPE
96: ,primary_flag per_all_assignments_f.primary_flag%TYPE
97: );
98:

Line 95: ,marital_status per_all_people_f.marital_status%TYPE

91: ,dob per_all_people_f.date_of_birth%TYPE
92: ,partner_last_name per_all_people_f.last_name%TYPE
93: ,partner_prefix per_all_people_f.pre_name_adjunct%TYPE
94: ,address_fem_ee per_all_people_f.per_information14%TYPE
95: ,marital_status per_all_people_f.marital_status%TYPE
96: ,primary_flag per_all_assignments_f.primary_flag%TYPE
97: );
98:
99: TYPE t_assig_details IS TABLE OF assig_details INDEX BY BINARY_INTEGER;