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_US_ARCH_MAG_COUNTY_V

Line 326: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,

322: 'TRANSFER_FIRST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_FN','TRANSFER_MN', ffai.value),
323: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
324: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
325: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
326: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,
327: per_all_people_f ppf,
328: ff_user_entities ffue,
329: ff_archive_items ffai,
330: pay_action_interlocks pai,

Line 391: and not exists (select null from pay_us_arch_mag_county_v -- pay_us_emp_county_tax_rules_f

387: -- and paa.assignment_action_id = pai.locking_action_id
388: and ppf.person_id = paf.person_id
389: -- and pes.assignment_id = paa.assignment_id
390: and pes.assignment_action_id = pai.locked_action_id
391: and not exists (select null from pay_us_arch_mag_county_v -- pay_us_emp_county_tax_rules_f
392: -- where state_code = pes.state_code
393: where substr(jurisdiction_code,1,2) = substr(pes.jurisdiction_code,1,2)
394: and assignment_action_id = pes.assignment_action_id )
395: -- and pay_magtape_generic.date_earned(ppa.effective_date, paa.assignment_id) between

Line 421: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,

417: 'TRANSFER_FIRST_NAME=P' , pay_mag_utils.get_parameter('TRANSFER_FN','TRANSFER_MN', ffai.value),
418: 'TRANSFER_MIDDLE_NAMES=P' , pay_mag_utils.get_parameter('TRANSFER_MN','TRANSFER_SSN', ffai.value),
419: 'TRANSFER_NATIONAL_IDENTIFIER=P' , pay_mag_utils.get_parameter('TRANSFER_SSN', '', ffai.value),
420: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
421: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,
422: per_all_people_f ppf,
423: ff_user_entities ffue,
424: ff_archive_items ffai,
425: pay_action_interlocks pai,

Line 491: and not exists (select null from pay_us_arch_mag_county_v -- pay_us_emp_county_tax_rules_f

487: and substr(pes.jurisdiction_code,1,2) = pus.state_code
488: and ffue.user_entity_name = 'A_PER_1099R_NAME'
489: and ffue.user_entity_id = ffai.user_entity_id
490: and ffai.context1 = pai.locked_action_id -- YREND pre-process aaid
491: and not exists (select null from pay_us_arch_mag_county_v -- pay_us_emp_county_tax_rules_f
492: -- where state_code = pes.state_code
493: where substr(jurisdiction_code,1,2) = substr(pes.jurisdiction_code,1,2)
494: -- and assignment_id = pes.assignment_id
495: and assignment_action_id = pes.assignment_action_id)