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_MAGTAPE_GENERIC

Line 19: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

15: , 'BUSINESS_GROUP_ID=P', fnd_number.number_to_canonical(ppa.business_group_id)
16: from pay_org_payment_methods_f opm
17: , pay_payroll_actions ppa
18: where ppa.payroll_action_id =
19: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
20: and ppa.org_payment_method_id = opm.org_payment_method_id
21: and ppa.effective_date between opm.effective_start_date
22: and opm.effective_end_date;
23: --

Line 35: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

31: , per_assignments paf
32: , pay_assignment_actions paa
33: where
34: paa.payroll_action_id =
35: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
36: and ppp.org_payment_method_id +0 =
37: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')
38: and paa.pre_payment_id = ppp.pre_payment_id
39: and paf.assignment_id = paa.assignment_id

Line 37: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')

33: where
34: paa.payroll_action_id =
35: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
36: and ppp.org_payment_method_id +0 =
37: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')
38: and paa.pre_payment_id = ppp.pre_payment_id
39: and paf.assignment_id = paa.assignment_id
40: group by paf.person_id;
41: --

Line 65: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

61: , per_people ppf
62: , per_assignments paf
63: , pay_assignment_actions paa
64: where paa.payroll_action_id =
65: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
66: and ppp.org_payment_method_id +0 =
67: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')
68: and opm.org_payment_method_id = ppm.org_payment_method_id
69: and ppm.external_account_id = pea.external_account_id

Line 67: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')

63: , pay_assignment_actions paa
64: where paa.payroll_action_id =
65: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
66: and ppp.org_payment_method_id +0 =
67: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')
68: and opm.org_payment_method_id = ppm.org_payment_method_id
69: and ppm.external_account_id = pea.external_account_id
70: and ppp.personal_payment_method_id = ppm.personal_payment_method_id
71: and paa.pre_payment_id = ppp.pre_payment_id

Line 75: pay_magtape_generic.get_parameter_value('TRANSFER_PERSON_ID')

71: and paa.pre_payment_id = ppp.pre_payment_id
72: and paf.person_id = ppf.person_id
73: and paf.assignment_id = paa.assignment_id
74: and ppf.person_id =
75: pay_magtape_generic.get_parameter_value('TRANSFER_PERSON_ID')
76: order by paf.assignment_number;
77: --
78: --
79: -- BANK OF Montreal (BMO) CURSORS

Line 99: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

95: , 'BUSINESS_GROUP_ID=P', fnd_number.number_to_canonical(ppa.business_group_id)
96: from pay_org_payment_methods_f opm
97: , pay_payroll_actions ppa
98: where ppa.payroll_action_id =
99: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
100: and ppa.org_payment_method_id = opm.org_payment_method_id
101: and ppa.effective_date between opm.effective_start_date
102: and opm.effective_end_date;
103: --

Line 115: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

111: , per_assignments paf
112: , pay_assignment_actions paa
113: where
114: paa.payroll_action_id =
115: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
116: and ppp.org_payment_method_id +0 =
117: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')
118: and paa.pre_payment_id = ppp.pre_payment_id
119: and paf.assignment_id = paa.assignment_id

Line 117: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')

113: where
114: paa.payroll_action_id =
115: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
116: and ppp.org_payment_method_id +0 =
117: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')
118: and paa.pre_payment_id = ppp.pre_payment_id
119: and paf.assignment_id = paa.assignment_id
120: group by paf.person_id;
121: --

Line 145: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

141: , per_people ppf
142: , per_assignments paf
143: , pay_assignment_actions paa
144: where paa.payroll_action_id =
145: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
146: and ppp.org_payment_method_id +0 =
147: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')
148: and opm.org_payment_method_id = ppm.org_payment_method_id
149: and ppm.external_account_id = pea.external_account_id

Line 147: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')

143: , pay_assignment_actions paa
144: where paa.payroll_action_id =
145: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
146: and ppp.org_payment_method_id +0 =
147: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')
148: and opm.org_payment_method_id = ppm.org_payment_method_id
149: and ppm.external_account_id = pea.external_account_id
150: and ppp.personal_payment_method_id = ppm.personal_payment_method_id
151: and paa.pre_payment_id = ppp.pre_payment_id

Line 155: pay_magtape_generic.get_parameter_value('TRANSFER_PERSON_ID')

151: and paa.pre_payment_id = ppp.pre_payment_id
152: and paf.person_id = ppf.person_id
153: and paf.assignment_id = paa.assignment_id
154: and ppf.person_id =
155: pay_magtape_generic.get_parameter_value('TRANSFER_PERSON_ID')
156: order by paf.assignment_number;
157: --
158: --
159: -- National Bank (BNC) CURSORS

Line 179: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

175: , 'BUSINESS_GROUP_ID=P', fnd_number.number_to_canonical(ppa.business_group_id)
176: from pay_org_payment_methods_f opm
177: , pay_payroll_actions ppa
178: where ppa.payroll_action_id =
179: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
180: and ppa.org_payment_method_id = opm.org_payment_method_id
181: and ppa.effective_date between opm.effective_start_date
182: and opm.effective_end_date;
183: --

Line 195: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

191: , per_assignments paf
192: , pay_assignment_actions paa
193: where
194: paa.payroll_action_id =
195: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
196: and ppp.org_payment_method_id +0 =
197: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')
198: and paa.pre_payment_id = ppp.pre_payment_id
199: and paf.assignment_id = paa.assignment_id

Line 197: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')

193: where
194: paa.payroll_action_id =
195: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
196: and ppp.org_payment_method_id +0 =
197: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')
198: and paa.pre_payment_id = ppp.pre_payment_id
199: and paf.assignment_id = paa.assignment_id
200: group by paf.person_id;
201: --

Line 226: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

222: , per_people ppf
223: , per_assignments paf
224: , pay_assignment_actions paa
225: where paa.payroll_action_id =
226: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
227: and ppp.org_payment_method_id +0 =
228: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')
229: and opm.org_payment_method_id = ppm.org_payment_method_id
230: and ppm.external_account_id = pea.external_account_id

Line 228: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')

224: , pay_assignment_actions paa
225: where paa.payroll_action_id =
226: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
227: and ppp.org_payment_method_id +0 =
228: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')
229: and opm.org_payment_method_id = ppm.org_payment_method_id
230: and ppm.external_account_id = pea.external_account_id
231: and ppp.personal_payment_method_id = ppm.personal_payment_method_id
232: and paa.pre_payment_id = ppp.pre_payment_id

Line 236: pay_magtape_generic.get_parameter_value('TRANSFER_PERSON_ID')

232: and paa.pre_payment_id = ppp.pre_payment_id
233: and paf.person_id = ppf.person_id
234: and paf.assignment_id = paa.assignment_id
235: and ppf.person_id =
236: pay_magtape_generic.get_parameter_value('TRANSFER_PERSON_ID')
237: order by paf.assignment_number;
238:
239: /* Bank of Nova Scotia */
240:

Line 262: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

258: from pay_org_payment_methods_f opm,
259: pay_external_accounts pea
260: , pay_payroll_actions ppa
261: where ppa.payroll_action_id =
262: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
263: and ppa.org_payment_method_id = opm.org_payment_method_id
264: and ppa.effective_date between opm.effective_start_date
265: and opm.effective_end_date
266: and opm.external_account_id = pea.external_account_id;

Line 279: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

275: , per_assignments paf
276: , pay_assignment_actions paa
277: where
278: paa.payroll_action_id =
279: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
280: and ppp.org_payment_method_id +0 =
281: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')
282: and paa.pre_payment_id = ppp.pre_payment_id
283: and paf.assignment_id = paa.assignment_id

Line 281: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')

277: where
278: paa.payroll_action_id =
279: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
280: and ppp.org_payment_method_id +0 =
281: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')
282: and paa.pre_payment_id = ppp.pre_payment_id
283: and paf.assignment_id = paa.assignment_id
284: group by paf.person_id;
285: --

Line 309: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

305: , per_people ppf
306: , per_assignments paf
307: , pay_assignment_actions paa
308: where paa.payroll_action_id =
309: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
310: and ppp.org_payment_method_id +0 =
311: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')
312: and opm.org_payment_method_id = ppm.org_payment_method_id
313: and ppm.external_account_id = pea.external_account_id

Line 311: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')

307: , pay_assignment_actions paa
308: where paa.payroll_action_id =
309: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
310: and ppp.org_payment_method_id +0 =
311: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METH')
312: and opm.org_payment_method_id = ppm.org_payment_method_id
313: and ppm.external_account_id = pea.external_account_id
314: and ppp.personal_payment_method_id = ppm.personal_payment_method_id
315: and paa.pre_payment_id = ppp.pre_payment_id

Line 319: pay_magtape_generic.get_parameter_value('TRANSFER_PERSON_ID')

315: and paa.pre_payment_id = ppp.pre_payment_id
316: and paf.person_id = ppf.person_id
317: and paf.assignment_id = paa.assignment_id
318: and ppf.person_id =
319: pay_magtape_generic.get_parameter_value('TRANSFER_PERSON_ID')
320: order by paf.assignment_number;
321: --
322: level_cnt number;
323: --