DBA Data[Home] [Help]

APPS.PAY_DIRECT_DEPOSIT_XML dependencies on FND_DATE

Line 44: fnd_date.date_to_canonical(nvl(overriding_dd_date

40: CURSOR c_get_header IS
41: select distinct 'PAYROLL_ACTION_ID=C',ppa.payroll_action_id,
42: 'TRANSFER_PAYROLL_ACTION_ID=P',ppa.payroll_action_id,
43: 'TRANSFER_DD_DATE=P',
44: fnd_date.date_to_canonical(nvl(overriding_dd_date
45: ,ppa.effective_date)),
46: 'TRANSFER_BUSINESS_GROUP_ID=P',business_group_id,
47: 'TRANSFER_EFFECTIVE_DATE=P',
48: fnd_date.date_to_canonical(ppa.effective_date),

Line 48: fnd_date.date_to_canonical(ppa.effective_date),

44: fnd_date.date_to_canonical(nvl(overriding_dd_date
45: ,ppa.effective_date)),
46: 'TRANSFER_BUSINESS_GROUP_ID=P',business_group_id,
47: 'TRANSFER_EFFECTIVE_DATE=P',
48: fnd_date.date_to_canonical(ppa.effective_date),
49: 'TRANSFER_ORG_PAY_METHOD=P',ppa.org_payment_method_id
50: from pay_payroll_actions ppa
51: where ppa.payroll_action_id =
52: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');