APPS.PAY_US_MMREF_REPORTING dependencies on FND_DATE

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

95: SELECT 'TAX_UNIT_ID=C' , HOI.organization_id,
96: 'JURISDICTION_CODE=C', SR.jurisdiction_code,
97: 'TRANSFER_JD=P', SR.jurisdiction_code,
98: 'ASSIGNMENT_ID=C' , '-1',
99: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
100: 'TRANSFER_HIGH_COUNT=P', '0',
101: 'TRANSFER_SCHOOL_DISTRICT=P', '-1',
102: 'TRANSFER_COUNTY=P', '-1',
103: 'TRANSFER_2678_FILER=P', HOI.org_information8,

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

148: SELECT 'TAX_UNIT_ID=C', HOI.organization_id,
149: 'JURISDICTION_CODE=C', 'DUMMY_VALUE',
150: 'TRANSFER_JD=P', 'DUMMY_VALUE',
151: 'ASSIGNMENT_ID=C' , '-1',
152: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
153: 'TRANSFER_HIGH_COUNT=P', '0',
154: 'TRANSFER_SCHOOL_DISTRICT=P', '-1',
155: 'TRANSFER_COUNTY=P', '-1',
156: 'TRANSFER_2678_FILER=P', HOI.org_information8,

Line 278: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned

274: --
275: CURSOR mmrf_employee IS
276: SELECT /*+ ORDERED */ 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
277: 'ASSIGNMENT_ID=C', AA.assignment_id,
278: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
279: (PA.effective_date, AA.assignment_id)),
280: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
281: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
282: FROM pay_payroll_actions PA,

Line 311: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned

307:
308: CURSOR govt_mmrf_employee IS
309: SELECT 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
310: 'ASSIGNMENT_ID=C', AA.assignment_id,
311: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
312: (PA.effective_date, AA.assignment_id)),
313: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
314: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
315: FROM per_all_people_f PE,

Line 359: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned

355:
356: CURSOR mmrf_pr_employee IS
357: SELECT 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
358: 'ASSIGNMENT_ID=C', AA.assignment_id,
359: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
360: (PA.effective_date, AA.assignment_id)),
361: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
362: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
363: FROM per_all_people_f PE,