eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PER_ALL_PEOPLE_F

Line 254: , per_all_people_f pap

250: , 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)
251: , 'FULL_NAME=P'
252: , pap.full_name
253: FROM per_all_assignments_f paf
254: , per_all_people_f pap
255: , hr_soft_coding_keyflex scl
256: , pay_payroll_actions ppa
257: , pay_assignment_actions paa
258: , pay_pre_payments ppp

Line 326: , per_all_people_f pap

322: , 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)
323: , 'FULL_NAME=P'
324: , pap.full_name
325: FROM per_all_assignments_f paf
326: , per_all_people_f pap
327: , hr_soft_coding_keyflex scl
328: , pay_payroll_actions ppa
329: , pay_assignment_actions paa
330: , pay_pre_payments ppp

Line 472: , per_all_people_f pap

468: , paa.ASSIGNMENT_ID
469: , 'DATE_EARNED=C'
470: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
471: FROM per_all_assignments_f paf
472: , per_all_people_f pap
473: , hr_soft_coding_keyflex scl
474: , pay_payroll_actions ppa
475: , pay_assignment_actions paa
476: , pay_pre_payments ppp

Line 597: , per_all_people_f pap

593: , paa.ASSIGNMENT_ID
594: , 'DATE_EARNED=C'
595: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
596: FROM per_all_assignments_f paf
597: , per_all_people_f pap
598: , hr_soft_coding_keyflex scl
599: , pay_payroll_actions ppa
600: , pay_assignment_actions paa
601: , pay_pre_payments ppp

Line 1049: , per_all_people_f pap

1045: , 'POST_CODE=P'
1046: , nvl(pad.postal_code,0)
1047: FROM per_addresses pad
1048: /* Modified for bug fix 4593682 */
1049: , per_all_people_f pap
1050: , pay_payroll_actions ppa
1051: WHERE pad.person_id (+)= pap.person_id
1052: AND pad.primary_flag = 'Y' --9403004
1053: AND ppa.effective_date BETWEEN nvl(pad.date_from,ppa.effective_date) AND nvl(pad.date_to,to_date('31-12-4712','dd-mm-rrrr')) --9403004