APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PER_ALL_PEOPLE_F

Line 137: , per_all_people_f pap

133: , substr(to_char(pap.national_identifier),1,instr(to_char(pap.national_identifier),'-')-1) ||substr(to_char(pap.national_identifier),instr(to_char(pap.national_identifier),'-')+1)--to_char(pap.national_identifier)
134: , 'FULL_NAME=P'
135: , pap.full_name
136: FROM per_all_assignments_f paf
137: , per_all_people_f pap
138: , hr_soft_coding_keyflex scl
139: , pay_payroll_actions ppa
140: , pay_assignment_actions paa
141: , pay_pre_payments ppp

Line 267: , per_all_people_f pap

263: , paa.ASSIGNMENT_ID
264: , 'DATE_EARNED=C'
265: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
266: FROM per_all_assignments_f paf
267: , per_all_people_f pap
268: , hr_soft_coding_keyflex scl
269: , pay_payroll_actions ppa
270: , pay_assignment_actions paa
271: , pay_pre_payments ppp

Line 365: , per_all_people_f pap

361: , paa.ASSIGNMENT_ID
362: , 'DATE_EARNED=C'
363: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
364: FROM per_all_assignments_f paf
365: , per_all_people_f pap
366: , hr_soft_coding_keyflex scl
367: , pay_payroll_actions ppa
368: , pay_assignment_actions paa
369: , pay_pre_payments ppp

Line 817: , per_all_people_f pap

813: , 'POST_CODE=P'
814: , nvl(pad.postal_code,0)
815: FROM per_addresses pad
816: /* Modified for bug fix 4593682 */
817: , per_all_people_f pap
818: WHERE pad.person_id (+)= pap.person_id
819: /* pad.person_id = pay_magtape_generic.get_parameter_value('TRANSFER_PERSON_ID') */
820: AND pap.person_id = pay_magtape_generic.get_parameter_value('TRANSFER_PERSON_ID')
821: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900);