eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_MMREF_REPORTING_MT dependencies on FND_DATE

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

46: SELECT 'TAX_UNIT_ID=C' , HOI.organization_id,
47: 'JURISDICTION_CODE=C', SR.jurisdiction_code,
48: 'TRANSFER_JD=P', SR.jurisdiction_code,
49: 'ASSIGNMENT_ID=C' , '-1',
50: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
51: 'TRANSFER_HIGH_COUNT=P', '0',
52: 'TRANSFER_SCHOOL_DISTRICT=P', '-1',
53: 'TRANSFER_COUNTY=P', '-1',
54: 'TRANSFER_2678_FILER=P', HOI.org_information8,

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

99: SELECT 'TAX_UNIT_ID=C', HOI.organization_id,
100: 'JURISDICTION_CODE=C', 'DUMMY_VALUE',
101: 'TRANSFER_JD=P', 'DUMMY_VALUE',
102: 'ASSIGNMENT_ID=C' , '-1',
103: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
104: 'TRANSFER_HIGH_COUNT=P', '0',
105: 'TRANSFER_SCHOOL_DISTRICT=P', '-1',
106: 'TRANSFER_COUNTY=P', '-1',
107: 'TRANSFER_2678_FILER=P', HOI.org_information8,

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

265:
266: CURSOR mmrf_employee IS
267: SELECT 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
268: 'ASSIGNMENT_ID=C', AA.assignment_id,
269: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
270: (PA.effective_date, AA.assignment_id)),
271: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
272: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
273: FROM per_all_people_f PE,

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

297:
298: CURSOR govt_mmrf_employee IS
299: SELECT 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
300: 'ASSIGNMENT_ID=C', AA.assignment_id,
301: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
302: (PA.effective_date, AA.assignment_id)),
303: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
304: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
305: FROM per_all_people_f PE,

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

345:
346: CURSOR mmrf_pr_employee IS
347: SELECT 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
348: 'ASSIGNMENT_ID=C', AA.assignment_id,
349: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
350: (PA.effective_date, AA.assignment_id)),
351: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
352: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
353: FROM per_all_people_f PE,

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

433: 'PAYROLL_ACTION_ID=C', pay_magtape_generic.get_parameter_value
434: ('TRANSFER_PAYROLL_ACTION_ID'),
435: 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
436: 'ASSIGNMENT_ID=C', AA.assignment_id,
437: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
438: (PA.effective_date, AA.assignment_id)),
439: 'JURISDICTION_CODE=C', pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
440: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id,
441: 'TAX_UNIT_ID=C',AA.TAX_UNIT_ID