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_IE_PAYPATH_TAPE dependencies on PAY_EXTERNAL_ACCOUNTS

Line 26: oea PAY_EXTERNAL_ACCOUNTS_PK,

22: popm PAY_ORG_PAYMENT_METHODS_F_PK,
23: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
24: a PER_ASSIGNMENTS_F_PK,
25: p PER_PEOPLE_F_PK ,
26: oea PAY_EXTERNAL_ACCOUNTS_PK,
27: pea PAY_EXTERNAL_ACCOUNTS_PK)
28: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,hou,org) */
29: 'VOLUME_ID=P' ,pay_magtape_generic.get_parameter_value('PAYPATH_VOLUME')
30: ,'PAYPATH_ID=P' ,pay_ie_archive_detail_pkg.get_paypathid --Bug no. 3813140

Line 27: pea PAY_EXTERNAL_ACCOUNTS_PK)

23: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
24: a PER_ASSIGNMENTS_F_PK,
25: p PER_PEOPLE_F_PK ,
26: oea PAY_EXTERNAL_ACCOUNTS_PK,
27: pea PAY_EXTERNAL_ACCOUNTS_PK)
28: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,hou,org) */
29: 'VOLUME_ID=P' ,pay_magtape_generic.get_parameter_value('PAYPATH_VOLUME')
30: ,'PAYPATH_ID=P' ,pay_ie_archive_detail_pkg.get_paypathid --Bug no. 3813140
31: ,'PROCESSING_DATE=P',to_char(to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYDDD')

Line 45: , pay_external_accounts oea

41: , pay_org_payment_methods_f popm
42: , pay_personal_payment_methods_f pppm
43: , per_all_assignments_f a
44: , per_all_people_f p
45: , pay_external_accounts oea
46: , pay_external_accounts pea
47: , hr_organization_units hou
48: , hr_organization_information org
49:

Line 46: , pay_external_accounts pea

42: , pay_personal_payment_methods_f pppm
43: , per_all_assignments_f a
44: , per_all_people_f p
45: , pay_external_accounts oea
46: , pay_external_accounts pea
47: , hr_organization_units hou
48: , hr_organization_information org
49:
50: -- , (select pay_ie_paypath_tape.get_paypathid pathid from dual) paypath -- Bug No 3060464

Line 94: oea PAY_EXTERNAL_ACCOUNTS_PK,

90: popm PAY_ORG_PAYMENT_METHODS_F_PK,
91: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
92: a PER_ASSIGNMENTS_F_PK,
93: p PER_PEOPLE_F_PK ,
94: oea PAY_EXTERNAL_ACCOUNTS_PK,
95: pea PAY_EXTERNAL_ACCOUNTS_PK,
96: org HR_ORGANIZATION_INFORMATIO_FK2)
97: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,org) */
98: 'TYPE=P', c_credit_type

Line 95: pea PAY_EXTERNAL_ACCOUNTS_PK,

91: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
92: a PER_ASSIGNMENTS_F_PK,
93: p PER_PEOPLE_F_PK ,
94: oea PAY_EXTERNAL_ACCOUNTS_PK,
95: pea PAY_EXTERNAL_ACCOUNTS_PK,
96: org HR_ORGANIZATION_INFORMATIO_FK2)
97: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,org) */
98: 'TYPE=P', c_credit_type
99: ,'EMP_NAME=P' , p.full_name

Line 118: , pay_external_accounts oea

114: , pay_org_payment_methods_f popm
115: , pay_personal_payment_methods_f pppm
116: , per_all_assignments_f a -- Bug No 3513042
117: , per_all_people_f p
118: , pay_external_accounts oea
119: , pay_external_accounts pea
120: , hr_organization_information org
121: where ppa.payroll_action_id = -- Bug No 3513042
122: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 119: , pay_external_accounts pea

115: , pay_personal_payment_methods_f pppm
116: , per_all_assignments_f a -- Bug No 3513042
117: , per_all_people_f p
118: , pay_external_accounts oea
119: , pay_external_accounts pea
120: , hr_organization_information org
121: where ppa.payroll_action_id = -- Bug No 3513042
122: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
123: and ppp.pre_payment_id = paa.pre_payment_id

Line 171: oea PAY_EXTERNAL_ACCOUNTS_PK,

167: popm PAY_ORG_PAYMENT_METHODS_F_PK,
168: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
169: a PER_ASSIGNMENTS_F_PK,
170: p PER_PEOPLE_F_PK ,
171: oea PAY_EXTERNAL_ACCOUNTS_PK,
172: pea PAY_EXTERNAL_ACCOUNTS_PK,
173: org HR_ORGANIZATION_INFORMATIO_FK2)
174: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,org) */
175: 'TYPE=P', 'Z'

Line 172: pea PAY_EXTERNAL_ACCOUNTS_PK,

168: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
169: a PER_ASSIGNMENTS_F_PK,
170: p PER_PEOPLE_F_PK ,
171: oea PAY_EXTERNAL_ACCOUNTS_PK,
172: pea PAY_EXTERNAL_ACCOUNTS_PK,
173: org HR_ORGANIZATION_INFORMATIO_FK2)
174: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,org) */
175: 'TYPE=P', 'Z'
176: ,'EMP_NAME=P' , 'null'

Line 195: , pay_external_accounts oea

191: , pay_org_payment_methods_f popm
192: , pay_personal_payment_methods_f pppm
193: , per_all_assignments_f a -- Bug No 3513042
194: , per_all_people_f p
195: , pay_external_accounts oea
196: , pay_external_accounts pea
197: , hr_organization_information org
198: where ppa.payroll_action_id = -- Bug No 3513042
199: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 196: , pay_external_accounts pea

192: , pay_personal_payment_methods_f pppm
193: , per_all_assignments_f a -- Bug No 3513042
194: , per_all_people_f p
195: , pay_external_accounts oea
196: , pay_external_accounts pea
197: , hr_organization_information org
198: where ppa.payroll_action_id = -- Bug No 3513042
199: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
200: and ppp.pre_payment_id = paa.pre_payment_id