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

Line 75: fnd_date changes.

71: check for all.
72: 30-AUG-99 rthakur 40.16/17 Fixed the Payer cursor it would not
73: pick up non-TCC GRE's.
74: 21-SEP-99 rthakur 115.1 Took the 110.7 of r11 and made the
75: fnd_date changes.
76: 01-dec-00 djoshi 115.2 Modified state_1099r_payee
77: cursor modified for indiana
78: 27-AUG-01 ekim 40.20 Added Vendor Information parameters
79: in us_1099r_transmitter cursor.

Line 83: 07-DEC-01 jgoswami 115.6 Added fnd_date.date_to_canonical to

79: in us_1099r_transmitter cursor.
80: 14-NOV-01 jgoswami 115.4 Added MMREF Cursors for State 1099r
81: Submitter, Payer and Payee.
82: 30-NOV-01 jgoswami 115.5 Added dbdrv command
83: 07-DEC-01 jgoswami 115.6 Added fnd_date.date_to_canonical to
84: MMREF Cursors.
85: 15-AUG-2002 ahanda 115.7 Changed transmitter cursor to remove
86: cartesian join
87: 11-nov-2002 djoshi 115.8 Added parameter to get contact Email

Line 312: 'DATE_EARNED=C' , fnd_date.date_to_canonical(Pay_Magtape_Generic.Date_Earned

308: select 'ASSIGNMENT_ACTION_ID=C' , pai.locked_action_id, -- YREND Pre-Processor aaid
309: 'ASSIGNMENT_ID=C' , paa.assignment_id,
310: 'JURISDICTION_CODE=C' , pec.jurisdiction_code,
311: 'TRANSFER_JURISDICTION_CODE=P' , pec.jurisdiction_code,
312: 'DATE_EARNED=C' , fnd_date.date_to_canonical(Pay_Magtape_Generic.Date_Earned
313: (ppa.effective_date,
314: paa.assignment_id)),
315: 'TRANSFER_LAST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_LN','TRANSFER_FN', ffai.value),
316: 'TRANSFER_FIRST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_FN','TRANSFER_MN', ffai.value),

Line 355: 'DATE_EARNED=C' , fnd_date.date_to_canonical(Pay_Magtape_Generic.Date_Earned

351: select 'ASSIGNMENT_ACTION_ID=C' , pai.locked_action_id,
352: 'ASSIGNMENT_ID=C' , paa.assignment_id,
353: 'JURISDICTION_CODE=C' , pes.jurisdiction_code,
354: 'TRANSFER_JURISDICTION_CODE=P' , pes.jurisdiction_code,
355: 'DATE_EARNED=C' , fnd_date.date_to_canonical(Pay_Magtape_Generic.Date_Earned
356: (ppa.effective_date,
357: paa.assignment_id)),
358: 'TRANSFER_LAST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_LN','TRANSFER_FN', ffai.value),
359: 'TRANSFER_FIRST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_FN','TRANSFER_MN', ffai.value),

Line 407: 'DATE_EARNED=C' , fnd_date.date_to_canonical(Pay_Magtape_Generic.Date_Earned

403: select 'ASSIGNMENT_ACTION_ID=C' , pai.locked_action_id,
404: 'ASSIGNMENT_ID=C' , paa.assignment_id,
405: 'JURISDICTION_CODE=C' , pec.jurisdiction_code,
406: 'TRANSFER_JURISDICTION_CODE=P' , pec.jurisdiction_code,
407: 'DATE_EARNED=C' , fnd_date.date_to_canonical(Pay_Magtape_Generic.Date_Earned
408: (ppa.effective_date,
409: paa.assignment_id)),
410: 'TRANSFER_LAST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_LN','TRANSFER_FN', ffai.value),
411: 'TRANSFER_FIRST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_FN','TRANSFER_MN', ffai.value),

Line 455: 'DATE_EARNED=C' , fnd_date.date_to_canonical(Pay_Magtape_Generic.Date_Earned

451: select 'ASSIGNMENT_ACTION_ID=C' , pai.locked_action_id,
452: 'ASSIGNMENT_ID=C' , paa.assignment_id,
453: 'JURISDICTION_CODE=C' , pes.jurisdiction_code,
454: 'TRANSFER_JURISDICTION_CODE=P' , pes.jurisdiction_code,
455: 'DATE_EARNED=C' , fnd_date.date_to_canonical(Pay_Magtape_Generic.Date_Earned
456: (ppa.effective_date,
457: paa.assignment_id)),
458: 'TRANSFER_LAST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_LN','TRANSFER_FN', ffai.value),
459: 'TRANSFER_FIRST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_FN','TRANSFER_MN', ffai.value),

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

541: SELECT 'TAX_UNIT_ID=C' , HOI.organization_id,
542: 'JURISDICTION_CODE=C', SR.jurisdiction_code,
543: 'TRANSFER_JD=P', SR.jurisdiction_code,
544: 'ASSIGNMENT_ID=C' , '-1',
545: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
546: 'TRANSFER_HIGH_COUNT=P', '0',
547: 'TRANSFER_SCHOOL_DISTRICT=P', '-1',
548: 'TRANSFER_COUNTY=P', '-1',
549: 'TRANSFER_2678_FILER=P', 'N',

Line 630: 'DATE_EARNED=C', fnd_date.date_to_canonical( pay_magtape_generic.date_earned (PA.effective_date, AA.assignment_id)),

626: CURSOR state_1099r_mmref_payee IS
627: SELECT
628: 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
629: 'ASSIGNMENT_ID=C', AA.assignment_id,
630: 'DATE_EARNED=C', fnd_date.date_to_canonical( pay_magtape_generic.date_earned (PA.effective_date, AA.assignment_id)),
631: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
632: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
633: FROM per_all_people_f PE,
634: per_all_assignments_f SS,