APPS.PAY_US_W2C_REPORTING_UTILS dependencies on FND_DATE

Line 80: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),

76: SELECT 'TAX_UNIT_ID=C', HOI.organization_id,
77: 'JURISDICTION_CODE=C', 'DUMMY_VALUE',
78: 'TRANSFER_JD=P', 'DUMMY_VALUE',
79: 'ASSIGNMENT_ID=C', '-1',
80: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
81: 'PAYROLL_ACTION_ID=C', ppa.payroll_action_id, -- payroll_action_id of YREND
82: 'TRANSFER_HIGH_COUNT=P', '0',
83: 'TRANSFER_SCHOOL_DISTRICT=P', '-1',
84: 'TRANSFER_COUNTY=P', '-1',

Line 155: 'DATE_EARNED=C', fnd_date.date_to_canonical(

151:
152: CURSOR w2c_mmrf2_employee IS
153: SELECT 'ASSIGNMENT_ACTION_ID=C', to_number(substr(AA.serial_number,1,15)), -- latest W2c Pre-Process Assignment Action Id
154: 'ASSIGNMENT_ID=C', AA.assignment_id,
155: 'DATE_EARNED=C', fnd_date.date_to_canonical(
156: pay_magtape_generic.date_earned(PA.effective_date, AA.assignment_id)),
157: 'JURISDICTION_CODE=C', pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
158: 'TRANSFER_OLD_ASG_ACTID=P', to_number(substr(AA.serial_number,16,15)), -- Originally Reported Assignment Action Id
159: 'TRANSFER_NEW_ASG_ACTID=P', to_number(substr(AA.serial_number,1,15)), -- Corrected Assignment Action Id