APPS.PAY_CA_DIRECT_DEPOSIT_PKG dependencies on PAY_ORG_PAYMENT_METHODS

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 57: pay_org_payment_methods opm

53: , 'CUSTOMER_NAME=P', ppf.full_name
54: , 'ORIGINATOR_SHR_NAME=P', opm.pmeth_information4
55: , 'CURRENCY_CODE=P', opm.currency_code
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

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 137: pay_org_payment_methods opm

133: , 'CUSTOMER_NAME=P', ppf.full_name
134: , 'ORIGINATOR_SHR_NAME=P', opm.pmeth_information4
135: , 'CURRENCY_CODE=P', opm.currency_code
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

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 218: pay_org_payment_methods opm

214: , 'CUSTOMER_FIRST_NAME=P', ppf.first_name
215: , 'ORIGINATOR_SHR_NAME=P', opm.pmeth_information4
216: , 'CURRENCY_CODE=P', opm.currency_code
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

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')

Line 301: pay_org_payment_methods opm

297: , 'CUSTOMER_NAME=P', ppf.full_name
298: , 'ORIGINATOR_SHR_NAME=P', opm.pmeth_information4
299: , 'CURRENCY_CODE=P', opm.currency_code
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