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 318: 'DATE_EARNED=C' , fnd_date.date_to_canonical(Pay_Magtape_Generic.Date_Earned

314: select 'ASSIGNMENT_ACTION_ID=C' , pai.locked_action_id, -- YREND Pre-Processor aaid
315: 'ASSIGNMENT_ID=C' , paa.assignment_id,
316: 'JURISDICTION_CODE=C' , pec.jurisdiction_code,
317: 'TRANSFER_JURISDICTION_CODE=P' , pec.jurisdiction_code,
318: 'DATE_EARNED=C' , fnd_date.date_to_canonical(Pay_Magtape_Generic.Date_Earned
319: (ppa.effective_date,
320: paa.assignment_id)),
321: 'TRANSFER_LAST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_LN','TRANSFER_FN', ffai.value),
322: 'TRANSFER_FIRST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_FN','TRANSFER_MN', ffai.value),

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

357: select 'ASSIGNMENT_ACTION_ID=C' , pai.locked_action_id,
358: 'ASSIGNMENT_ID=C' , paa.assignment_id,
359: 'JURISDICTION_CODE=C' , pes.jurisdiction_code,
360: 'TRANSFER_JURISDICTION_CODE=P' , pes.jurisdiction_code,
361: 'DATE_EARNED=C' , fnd_date.date_to_canonical(Pay_Magtape_Generic.Date_Earned
362: (ppa.effective_date,
363: paa.assignment_id)),
364: 'TRANSFER_LAST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_LN','TRANSFER_FN', ffai.value),
365: 'TRANSFER_FIRST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_FN','TRANSFER_MN', ffai.value),

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

409: select 'ASSIGNMENT_ACTION_ID=C' , pai.locked_action_id,
410: 'ASSIGNMENT_ID=C' , paa.assignment_id,
411: 'JURISDICTION_CODE=C' , pec.jurisdiction_code,
412: 'TRANSFER_JURISDICTION_CODE=P' , pec.jurisdiction_code,
413: 'DATE_EARNED=C' , fnd_date.date_to_canonical(Pay_Magtape_Generic.Date_Earned
414: (ppa.effective_date,
415: paa.assignment_id)),
416: 'TRANSFER_LAST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_LN','TRANSFER_FN', ffai.value),
417: 'TRANSFER_FIRST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_FN','TRANSFER_MN', ffai.value),

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

457: select 'ASSIGNMENT_ACTION_ID=C' , pai.locked_action_id,
458: 'ASSIGNMENT_ID=C' , paa.assignment_id,
459: 'JURISDICTION_CODE=C' , pes.jurisdiction_code,
460: 'TRANSFER_JURISDICTION_CODE=P' , pes.jurisdiction_code,
461: 'DATE_EARNED=C' , fnd_date.date_to_canonical(Pay_Magtape_Generic.Date_Earned
462: (ppa.effective_date,
463: paa.assignment_id)),
464: 'TRANSFER_LAST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_LN','TRANSFER_FN', ffai.value),
465: 'TRANSFER_FIRST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_FN','TRANSFER_MN', ffai.value),

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

552: SELECT 'TAX_UNIT_ID=C' , HOI.organization_id,
553: 'JURISDICTION_CODE=C', SR.jurisdiction_code,
554: 'TRANSFER_JD=P', SR.jurisdiction_code,
555: 'ASSIGNMENT_ID=C' , '-1',
556: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
557: 'TRANSFER_HIGH_COUNT=P', '0',
558: 'TRANSFER_SCHOOL_DISTRICT=P', '-1',
559: 'TRANSFER_COUNTY=P', '-1',
560: 'TRANSFER_2678_FILER=P', 'N',

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

637: CURSOR state_1099r_mmref_payee IS
638: SELECT
639: 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
640: 'ASSIGNMENT_ID=C', AA.assignment_id,
641: 'DATE_EARNED=C', fnd_date.date_to_canonical( pay_magtape_generic.date_earned (PA.effective_date, AA.assignment_id)),
642: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
643: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
644: FROM per_all_people_f PE,
645: per_all_assignments_f SS,