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 PAY_MAG_UTILS

Line 162: and rtrim(ltrim(Pay_Mag_Utils.Get_Parameter('TRANSFER_TRANS_LEGAL_CO_ID','TRANSFER_ALL_PAYERS',ppa2.legislative_parameters))) =

158: and ppa.report_type = 'YREND'
159: and ppa.effective_date = ppa2.effective_date
160: and ppa.business_group_id + 0 = ppa2.business_group_id
161: and ppa.action_status = 'C'
162: and rtrim(ltrim(Pay_Mag_Utils.Get_Parameter('TRANSFER_TRANS_LEGAL_CO_ID','TRANSFER_ALL_PAYERS',ppa2.legislative_parameters))) =
163: ffaic.context
164: and ppa.payroll_action_id = fai.context1
165: and fai.context1 = fai2.context1
166: and fue2.user_entity_name = 'A_US_1099R_TRANSMITTER_CODE'

Line 179: and hoi.organization_id = rtrim(ltrim(Pay_Mag_Utils.Get_Parameter(

175: /* and hoi.organization_id = ffaic.context */
176: /* Commented to avoid cartesian join issue */
177: /* and hoi.organization_id
178: = Pay_Magtape_Generic.Get_Parameter_Value('TRANSFER_TRANS_LEGAL_CO_ID') */
179: and hoi.organization_id = rtrim(ltrim(Pay_Mag_Utils.Get_Parameter(
180: 'TRANSFER_TRANS_LEGAL_CO_ID',
181: 'TRANSFER_ALL_PAYERS',
182: ppa2.legislative_parameters)))
183: and hoi.org_information_context = '1099R Magnetic Report Rules'

Line 220: and rtrim(ltrim(Pay_Mag_Utils.Get_Parameter('TRANSFER_TRANS_LEGAL_CO_ID','TRANSFER_ALL_PAYERS',ppa2.legislative_parameters))) =

216: and ppa.report_type = 'YREND'
217: and ppa.effective_date = ppa2.effective_date
218: and ppa.business_group_id + 0 = ppa2.business_group_id
219: and ppa.action_status = 'C'
220: and rtrim(ltrim(Pay_Mag_Utils.Get_Parameter('TRANSFER_TRANS_LEGAL_CO_ID','TRANSFER_ALL_PAYERS',ppa2.legislative_parameters))) =
221: ffaic.context
222: and ppa.payroll_action_id = fai.context1
223: and fai.context1 = fai2.context1
224: and fue2.user_entity_name = 'A_US_1099R_TRANSMITTER_CODE'

Line 237: and hoi.organization_id = rtrim(ltrim(Pay_Mag_Utils.Get_Parameter(

233: /* and hoi.organization_id = ffaic.context */
234: /* Commented to avoid cartesian join issue */
235: /* and hoi.organization_id
236: = Pay_Magtape_Generic.Get_Parameter_Value('TRANSFER_TRANS_LEGAL_CO_ID') */
237: and hoi.organization_id = rtrim(ltrim(Pay_Mag_Utils.Get_Parameter(
238: 'TRANSFER_TRANS_LEGAL_CO_ID',
239: 'TRANSFER_ALL_PAYERS',
240: ppa2.legislative_parameters)))
241: and hoi.org_information_context = '1099R Magnetic Report Rules'

Line 315: 'TRANSFER_LAST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_LN','TRANSFER_FN', ffai.value),

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),
317: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
318: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
319: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid

Line 316: 'TRANSFER_FIRST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_FN','TRANSFER_MN', ffai.value),

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),
317: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
318: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
319: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
320: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,

Line 317: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),

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),
317: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
318: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
319: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
320: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,
321: per_all_people_f ppf,

Line 318: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),

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),
317: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
318: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
319: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
320: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,
321: per_all_people_f ppf,
322: ff_user_entities ffue,

Line 344: and Pay_Mag_Utils.Date_Earned(ppa.effective_date,

340: -- and pec.assignment_id = paa.assignment_id
341: and pec.assignment_action_id = pai.locked_action_id
342: -- and pay_magtape_generic.date_earned(ppa.effective_date, paa.assignment_id) between
343: -- pec.effective_start_date AND pec.effective_end_date
344: and Pay_Mag_Utils.Date_Earned(ppa.effective_date,
345: paa.assignment_id,
346: paf.effective_start_date,
347: paf.effective_end_date,
348: ppf.effective_start_date,

Line 358: 'TRANSFER_LAST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_LN','TRANSFER_FN', ffai.value),

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),
360: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
361: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
362: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid

Line 359: 'TRANSFER_FIRST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_FN','TRANSFER_MN', ffai.value),

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),
360: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
361: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
362: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
363: from pay_us_arch_mag_state_v pes, -- pay_us_emp_state_tax_rules_f pes,

Line 360: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),

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),
360: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
361: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
362: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
363: from pay_us_arch_mag_state_v pes, -- pay_us_emp_state_tax_rules_f pes,
364: per_all_people_f ppf,

Line 361: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),

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),
360: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
361: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
362: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
363: from pay_us_arch_mag_state_v pes, -- pay_us_emp_state_tax_rules_f pes,
364: per_all_people_f ppf,
365: ff_user_entities ffue,

Line 391: and Pay_Mag_Utils.Date_Earned(ppa.effective_date,

387: where substr(jurisdiction_code,1,2) = substr(pes.jurisdiction_code,1,2)
388: and assignment_action_id = pes.assignment_action_id )
389: -- and pay_magtape_generic.date_earned(ppa.effective_date, paa.assignment_id) between
390: -- pes.effective_start_date AND pes.effective_end_date
391: and Pay_Mag_Utils.Date_Earned(ppa.effective_date,
392: paa.assignment_id,
393: paf.effective_start_date,
394: paf.effective_end_date,
395: ppf.effective_start_date,

Line 410: 'TRANSFER_LAST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_LN','TRANSFER_FN', ffai.value),

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),
412: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
413: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
414: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid

Line 411: 'TRANSFER_FIRST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_FN','TRANSFER_MN', ffai.value),

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),
412: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
413: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
414: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
415: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,

Line 412: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),

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),
412: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
413: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
414: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
415: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,
416: per_all_people_f ppf,

Line 413: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),

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),
412: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
413: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
414: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
415: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,
416: per_all_people_f ppf,
417: ff_user_entities ffue,

Line 443: and Pay_Mag_Utils.Date_Earned(ppa.effective_date,

439: and pus.state_abbrev= Pay_Magtape_Generic.Get_Parameter_Value
440: ('TRANSFER_STATE')
441: -- and pay_magtape_generic.date_earned(ppa.effective_date, paa.assignment_id) between
442: -- pec.effective_start_date AND pec.effective_end_date
443: and Pay_Mag_Utils.Date_Earned(ppa.effective_date,
444: paa.assignment_id,
445: paf.effective_start_date,
446: paf.effective_end_date,
447: ppf.effective_start_date,

Line 458: 'TRANSFER_LAST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_LN','TRANSFER_FN', ffai.value),

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),
460: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
461: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
462: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid

Line 459: 'TRANSFER_FIRST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_FN','TRANSFER_MN', ffai.value),

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),
460: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
461: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
462: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
463: from pay_us_arch_mag_state_v pes, -- pay_us_emp_state_tax_rules_f pes,

Line 460: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),

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),
460: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
461: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
462: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
463: from pay_us_arch_mag_state_v pes, -- pay_us_emp_state_tax_rules_f pes,
464: per_all_people_f ppf,

Line 461: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),

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),
460: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
461: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
462: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
463: from pay_us_arch_mag_state_v pes, -- pay_us_emp_state_tax_rules_f pes,
464: per_all_people_f ppf,
465: ff_user_entities ffue,

Line 496: and Pay_Mag_Utils.Date_Earned(ppa.effective_date,

492: and paa.tax_unit_id = Pay_Magtape_Generic.Get_Parameter_Value
493: ('TAX_UNIT_ID')
494: and pus.state_abbrev= Pay_Magtape_Generic.Get_Parameter_Value
495: ('TRANSFER_STATE')
496: and Pay_Mag_Utils.Date_Earned(ppa.effective_date,
497: paa.assignment_id,
498: paf.effective_start_date,
499: paf.effective_end_date,
500: ppf.effective_start_date,