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_ORG_PAYMENT_METHODS_F

Line 16: from pay_org_payment_methods_f opm

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')
20: and ppa.org_payment_method_id = opm.org_payment_method_id

Line 96: from pay_org_payment_methods_f opm

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')
100: and ppa.org_payment_method_id = opm.org_payment_method_id

Line 176: from pay_org_payment_methods_f opm

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')
180: and ppa.org_payment_method_id = opm.org_payment_method_id

Line 258: from pay_org_payment_methods_f opm,

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 =
262: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')