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.

[Home] [Help]

APPS.PAY_US_MMREF_REPORTING_MT dependencies on FND_DATE

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

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

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

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

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

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

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

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

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

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

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

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