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 320: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,

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,
323: ff_archive_items ffai,
324: pay_action_interlocks pai,

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

381: -- and paa.assignment_action_id = pai.locking_action_id
382: and ppf.person_id = paf.person_id
383: -- and pes.assignment_id = paa.assignment_id
384: and pes.assignment_action_id = pai.locked_action_id
385: and not exists (select null from pay_us_arch_mag_county_v -- pay_us_emp_county_tax_rules_f
386: -- where state_code = pes.state_code
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

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

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,
418: ff_archive_items ffai,
419: pay_action_interlocks pai,

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

481: and substr(pes.jurisdiction_code,1,2) = pus.state_code
482: and ffue.user_entity_name = 'A_PER_1099R_NAME'
483: and ffue.user_entity_id = ffai.user_entity_id
484: and ffai.context1 = pai.locked_action_id -- YREND pre-process aaid
485: and not exists (select null from pay_us_arch_mag_county_v -- pay_us_emp_county_tax_rules_f
486: -- where state_code = pes.state_code
487: where substr(jurisdiction_code,1,2) = substr(pes.jurisdiction_code,1,2)
488: -- and assignment_id = pes.assignment_id
489: and assignment_action_id = pes.assignment_action_id)