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_REPORTING1 dependencies on FND_DATE

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

83: SELECT 'TAX_UNIT_ID=C' , HOI.organization_id,
84: 'JURISDICTION_CODE=C', SR.jurisdiction_code,
85: 'TRANSFER_JD=P', SR.jurisdiction_code,
86: 'ASSIGNMENT_ID=C' , '-1',
87: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
88: 'TRANSFER_HIGH_COUNT=P', '0',
89: 'TRANSFER_SCHOOL_DISTRICT=P', '-1',
90: 'TRANSFER_COUNTY=P', '-1',
91: 'TRANSFER_2678_FILER=P', HOI.org_information8,

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

136: SELECT 'TAX_UNIT_ID=C', HOI.organization_id,
137: 'JURISDICTION_CODE=C', 'DUMMY_VALUE',
138: 'TRANSFER_JD=P', 'DUMMY_VALUE',
139: 'ASSIGNMENT_ID=C' , '-1',
140: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
141: 'TRANSFER_HIGH_COUNT=P', '0',
142: 'TRANSFER_SCHOOL_DISTRICT=P', '-1',
143: 'TRANSFER_COUNTY=P', '-1',
144: 'TRANSFER_2678_FILER=P', HOI.org_information8,

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

302:
303: CURSOR mmrf_employee IS
304: SELECT 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
305: 'ASSIGNMENT_ID=C', AA.assignment_id,
306: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
307: (PA.effective_date, AA.assignment_id)),
308: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
309: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
310: FROM per_all_people_f PE,

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

335:
336: CURSOR govt_mmrf_employee IS
337: SELECT 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
338: 'ASSIGNMENT_ID=C', AA.assignment_id,
339: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
340: (PA.effective_date, AA.assignment_id)),
341: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
342: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
343: FROM per_all_people_f PE,

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

383:
384: CURSOR mmrf_pr_employee IS
385: SELECT 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
386: 'ASSIGNMENT_ID=C', AA.assignment_id,
387: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
388: (PA.effective_date, AA.assignment_id)),
389: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
390: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
391: FROM per_all_people_f PE,

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

471: 'PAYROLL_ACTION_ID=C',pay_magtape_generic.get_parameter_value
472: ('TRANSFER_PAYROLL_ACTION_ID'),
473: 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
474: 'ASSIGNMENT_ID=C', AA.assignment_id,
475: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
476: (PA.effective_date, AA.assignment_id)),
477: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
478: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id,
479: 'TAX_UNIT_ID=C',AA.TAX_UNIT_ID