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_CA_DIRECT_DEPOSIT_PKG dependencies on PAY_PRE_PAYMENTS

Line 30: pay_pre_payments ppp

26: select
27: 'TRANSFER_COUNT=P', count(paf.person_id)
28: , 'TRANSFER_PERSON_ID=P', paf.person_id
29: from
30: pay_pre_payments ppp
31: , per_assignments paf
32: , pay_assignment_actions paa
33: where
34: paa.payroll_action_id =

Line 60: , pay_pre_payments ppp

56: from
57: pay_org_payment_methods opm
58: , pay_personal_payment_methods ppm
59: , pay_external_accounts pea
60: , pay_pre_payments ppp
61: , per_people ppf
62: , per_assignments paf
63: , pay_assignment_actions paa
64: where paa.payroll_action_id =

Line 110: pay_pre_payments ppp

106: select
107: 'TRANSFER_COUNT=P', count(paf.person_id)
108: , 'TRANSFER_PERSON_ID=P', paf.person_id
109: from
110: pay_pre_payments ppp
111: , per_assignments paf
112: , pay_assignment_actions paa
113: where
114: paa.payroll_action_id =

Line 140: , pay_pre_payments ppp

136: from
137: pay_org_payment_methods opm
138: , pay_personal_payment_methods ppm
139: , pay_external_accounts pea
140: , pay_pre_payments ppp
141: , per_people ppf
142: , per_assignments paf
143: , pay_assignment_actions paa
144: where paa.payroll_action_id =

Line 190: pay_pre_payments ppp

186: select
187: 'TRANSFER_COUNT=P', count(paf.person_id)
188: , 'TRANSFER_PERSON_ID=P', paf.person_id
189: from
190: pay_pre_payments ppp
191: , per_assignments paf
192: , pay_assignment_actions paa
193: where
194: paa.payroll_action_id =

Line 221: , pay_pre_payments ppp

217: from
218: pay_org_payment_methods opm
219: , pay_personal_payment_methods ppm
220: , pay_external_accounts pea
221: , pay_pre_payments ppp
222: , per_people ppf
223: , per_assignments paf
224: , pay_assignment_actions paa
225: where paa.payroll_action_id =

Line 274: pay_pre_payments ppp

270: select
271: 'TRANSFER_COUNT=P', count(paf.person_id)
272: , 'TRANSFER_PERSON_ID=P', paf.person_id
273: from
274: pay_pre_payments ppp
275: , per_assignments paf
276: , pay_assignment_actions paa
277: where
278: paa.payroll_action_id =

Line 304: , pay_pre_payments ppp

300: from
301: pay_org_payment_methods opm
302: , pay_personal_payment_methods ppm
303: , pay_external_accounts pea
304: , pay_pre_payments ppp
305: , per_people ppf
306: , per_assignments paf
307: , pay_assignment_actions paa
308: where paa.payroll_action_id =