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 FND_NUMBER

Line 9: , 'TRANSFER_ORG_PAY_METH=P', fnd_number.number_to_canonical(opm.org_payment_method_id)

5: --
6: CURSOR rbc_header IS
7: select
8: 'ORG_PAY_METHOD_ID=C', opm.org_payment_method_id
9: , 'TRANSFER_ORG_PAY_METH=P', fnd_number.number_to_canonical(opm.org_payment_method_id)
10: , 'ORIGINATOR_ID=P', opm.pmeth_information2
11: , 'ORIGINATOR_NAME=P', opm.pmeth_information3
12: , 'TRANSFER_PAY_ACT_ID=P', fnd_number.number_to_canonical(ppa.payroll_action_id)
13: , 'TRANSFER_DD_DATE=P', nvl(to_char(ppa.overriding_dd_date,'YYYYDDD'),

Line 12: , 'TRANSFER_PAY_ACT_ID=P', fnd_number.number_to_canonical(ppa.payroll_action_id)

8: 'ORG_PAY_METHOD_ID=C', opm.org_payment_method_id
9: , 'TRANSFER_ORG_PAY_METH=P', fnd_number.number_to_canonical(opm.org_payment_method_id)
10: , 'ORIGINATOR_ID=P', opm.pmeth_information2
11: , 'ORIGINATOR_NAME=P', opm.pmeth_information3
12: , 'TRANSFER_PAY_ACT_ID=P', fnd_number.number_to_canonical(ppa.payroll_action_id)
13: , 'TRANSFER_DD_DATE=P', nvl(to_char(ppa.overriding_dd_date,'YYYYDDD'),
14: to_char(ppa.effective_date,'YYYYDDD'))
15: , 'BUSINESS_GROUP_ID=P', fnd_number.number_to_canonical(ppa.business_group_id)
16: from pay_org_payment_methods_f opm

Line 15: , 'BUSINESS_GROUP_ID=P', fnd_number.number_to_canonical(ppa.business_group_id)

11: , 'ORIGINATOR_NAME=P', opm.pmeth_information3
12: , 'TRANSFER_PAY_ACT_ID=P', fnd_number.number_to_canonical(ppa.payroll_action_id)
13: , 'TRANSFER_DD_DATE=P', nvl(to_char(ppa.overriding_dd_date,'YYYYDDD'),
14: to_char(ppa.effective_date,'YYYYDDD'))
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')

Line 84: , 'TRANSFER_ORG_PAY_METH=P', fnd_number.number_to_canonical(opm.org_payment_method_id)

80: --
81: CURSOR bmo_header IS
82: select
83: 'ORG_PAY_METHOD_ID=C', opm.org_payment_method_id
84: , 'TRANSFER_ORG_PAY_METH=P', fnd_number.number_to_canonical(opm.org_payment_method_id)
85: , 'ORIGINATOR_ID=P', opm.pmeth_information2
86: , 'ORIGINATOR_NAME=P', opm.pmeth_information3
87: , 'ORIGINATOR_SHR_NAME=P', opm.pmeth_information4
88: , 'TRANSFER_PAY_ACT_ID=P', fnd_number.number_to_canonical(ppa.payroll_action_id)

Line 88: , 'TRANSFER_PAY_ACT_ID=P', fnd_number.number_to_canonical(ppa.payroll_action_id)

84: , 'TRANSFER_ORG_PAY_METH=P', fnd_number.number_to_canonical(opm.org_payment_method_id)
85: , 'ORIGINATOR_ID=P', opm.pmeth_information2
86: , 'ORIGINATOR_NAME=P', opm.pmeth_information3
87: , 'ORIGINATOR_SHR_NAME=P', opm.pmeth_information4
88: , 'TRANSFER_PAY_ACT_ID=P', fnd_number.number_to_canonical(ppa.payroll_action_id)
89: , 'TRANSFER_DD_DATE=P', nvl(to_char(ppa.overriding_dd_date,'YYDDD'),to_char(ppa.effective_date,'YYDDD'))
90: , 'DES_DATA_CENTRE=P', opm.pmeth_information8
91: , 'CPA_CODE=P', opm.pmeth_information7
92: , 'RETURN_BANK_NUMBER=P', substr(opm.pmeth_information5,2,3)

Line 95: , 'BUSINESS_GROUP_ID=P', fnd_number.number_to_canonical(ppa.business_group_id)

91: , 'CPA_CODE=P', opm.pmeth_information7
92: , 'RETURN_BANK_NUMBER=P', substr(opm.pmeth_information5,2,3)
93: , 'RETURN_TRANSIT_NUMBER=P', substr(opm.pmeth_information5,5,5)
94: , 'RETURN_ACCOUNT_NUMBER=P', opm.pmeth_information6
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')

Line 165: , 'TRANSFER_ORG_PAY_METH=P', fnd_number.number_to_canonical(opm.org_payment_method_id)

161: --
162: CURSOR bnc_header IS
163: select
164: 'ORG_PAY_METHOD_ID=C', opm.org_payment_method_id
165: , 'TRANSFER_ORG_PAY_METH=P', fnd_number.number_to_canonical(opm.org_payment_method_id)
166: , 'ORIGINATOR_ID=P', opm.pmeth_information2
167: , 'ORIGINATOR_NAME=P', opm.pmeth_information3
168: , 'ORIGINATOR_SHR_NAME=P', opm.pmeth_information4
169: , 'TRANSFER_PAY_ACT_ID=P', fnd_number.number_to_canonical(ppa.payroll_action_id)

Line 169: , 'TRANSFER_PAY_ACT_ID=P', fnd_number.number_to_canonical(ppa.payroll_action_id)

165: , 'TRANSFER_ORG_PAY_METH=P', fnd_number.number_to_canonical(opm.org_payment_method_id)
166: , 'ORIGINATOR_ID=P', opm.pmeth_information2
167: , 'ORIGINATOR_NAME=P', opm.pmeth_information3
168: , 'ORIGINATOR_SHR_NAME=P', opm.pmeth_information4
169: , 'TRANSFER_PAY_ACT_ID=P', fnd_number.number_to_canonical(ppa.payroll_action_id)
170: , 'TRANSFER_DD_DATE=P', nvl(to_char(ppa.overriding_dd_date,'YYDDD'),to_char(ppa.effective_date,'YYDDD'))
171: , 'CPA_CODE=P', opm.pmeth_information7
172: , 'RETURN_BANK_NUMBER=P', substr(opm.pmeth_information5,2,3)
173: , 'RETURN_TRANSIT_NUMBER=P', substr(opm.pmeth_information5,5,5)

Line 175: , 'BUSINESS_GROUP_ID=P', fnd_number.number_to_canonical(ppa.business_group_id)

171: , 'CPA_CODE=P', opm.pmeth_information7
172: , 'RETURN_BANK_NUMBER=P', substr(opm.pmeth_information5,2,3)
173: , 'RETURN_TRANSIT_NUMBER=P', substr(opm.pmeth_information5,5,5)
174: , 'RETURN_ACCOUNT_NUMBER=P', opm.pmeth_information6
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')

Line 244: , 'TRANSFER_ORG_PAY_METH=P', fnd_number.number_to_canonical(opm.org_payment_method_id)

240:
241: CURSOR bnvsc_header IS
242: select
243: 'ORG_PAY_METHOD_ID=C', opm.org_payment_method_id
244: , 'TRANSFER_ORG_PAY_METH=P', fnd_number.number_to_canonical(opm.org_payment_method_id)
245: , 'ORIGINATOR_ID=P', opm.pmeth_information2
246: , 'ORIGINATOR_NAME=P', opm.pmeth_information3
247: , 'ORIGINATOR_SHR_NAME=P', opm.pmeth_information4
248: , 'TRANSFER_PAY_ACT_ID=P', fnd_number.number_to_canonical(ppa.payroll_action_id)

Line 248: , 'TRANSFER_PAY_ACT_ID=P', fnd_number.number_to_canonical(ppa.payroll_action_id)

244: , 'TRANSFER_ORG_PAY_METH=P', fnd_number.number_to_canonical(opm.org_payment_method_id)
245: , 'ORIGINATOR_ID=P', opm.pmeth_information2
246: , 'ORIGINATOR_NAME=P', opm.pmeth_information3
247: , 'ORIGINATOR_SHR_NAME=P', opm.pmeth_information4
248: , 'TRANSFER_PAY_ACT_ID=P', fnd_number.number_to_canonical(ppa.payroll_action_id)
249: , 'TRANSFER_DD_DATE=P', nvl(to_char(ppa.overriding_dd_date,'YYDDD'),to_char(ppa.effective_date,'YYDDD'))
250: , 'CPA_CODE=P', opm.pmeth_information7
251: , 'RETURN_BANK_NUMBER=P', substr(opm.pmeth_information5,2,3)
252: , 'RETURN_TRANSIT_NUMBER=P', substr(opm.pmeth_information5,5,5)

Line 257: , 'BUSINESS_GROUP_ID=P', fnd_number.number_to_canonical(ppa.business_group_id)

253: , 'RETURN_ACCOUNT_NUMBER=P', opm.pmeth_information6
254: , 'DES_DATA_CENTRE=P', opm.pmeth_information8
255: , 'RETURN_BANK_TRANSIT_NUMBER=P', pea.segment4
256: , 'BANK_NUMBER=P', pea.segment7
257: , 'BUSINESS_GROUP_ID=P', fnd_number.number_to_canonical(ppa.business_group_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 =