DBA Data[Home] [Help]

APPS.PAY_CA_DIRECT_DEPOSIT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 17: , pay_payroll_actions ppa

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
21: and ppa.effective_date between opm.effective_start_date

Line 97: , pay_payroll_actions ppa

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
101: and ppa.effective_date between opm.effective_start_date

Line 177: , pay_payroll_actions ppa

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
181: and ppa.effective_date between opm.effective_start_date

Line 260: , pay_payroll_actions ppa

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')
263: and ppa.org_payment_method_id = opm.org_payment_method_id
264: and ppa.effective_date between opm.effective_start_date