APPS.PAY_US_MMREF_REPORTING dependencies on FND_DATE

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

102: SELECT 'TAX_UNIT_ID=C' , HOI.organization_id,
103: 'JURISDICTION_CODE=C', SR.jurisdiction_code,
104: 'TRANSFER_JD=P', SR.jurisdiction_code,
105: 'ASSIGNMENT_ID=C' , '-1',
106: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
107: 'TRANSFER_HIGH_COUNT=P', '0',
108: 'TRANSFER_SCHOOL_DISTRICT=P', '-1',
109: 'TRANSFER_COUNTY=P', '-1',
110: 'TRANSFER_2678_FILER=P', HOI.org_information8,

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

155: SELECT 'TAX_UNIT_ID=C', HOI.organization_id,
156: 'JURISDICTION_CODE=C', 'DUMMY_VALUE',
157: 'TRANSFER_JD=P', 'DUMMY_VALUE',
158: 'ASSIGNMENT_ID=C' , '-1',
159: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
160: 'TRANSFER_HIGH_COUNT=P', '0',
161: 'TRANSFER_SCHOOL_DISTRICT=P', '-1',
162: 'TRANSFER_COUNTY=P', '-1',
163: 'TRANSFER_2678_FILER=P', HOI.org_information8,

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

284: --
285: CURSOR mmrf_employee IS
286: SELECT /*+ ORDERED */ 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
287: 'ASSIGNMENT_ID=C', AA.assignment_id,
288: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
289: (PA.effective_date, AA.assignment_id)),
290: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
291: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
292: FROM pay_payroll_actions PA,

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

317:
318: CURSOR govt_mmrf_employee IS
319: SELECT 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
320: 'ASSIGNMENT_ID=C', AA.assignment_id,
321: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
322: (PA.effective_date, AA.assignment_id)),
323: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
324: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
325: FROM per_all_people_f PE,

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

365:
366: CURSOR mmrf_pr_employee IS
367: SELECT 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
368: 'ASSIGNMENT_ID=C', AA.assignment_id,
369: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
370: (PA.effective_date, AA.assignment_id)),
371: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
372: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
373: FROM per_all_people_f PE,