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_ASSIGNMENT_ACTIONS

Line 294: and exists (select 'Y' from pay_assignment_actions paa

290: and ffai3.context1 = ffai2.context1
291: and ffaic2.context_id = ffc.context_id
292: and (Pay_Magtape_Generic.Get_Parameter_value('TRANSFER_ALL_PAYERS') = 'Y'
293: OR ffaic2.context = Pay_Magtape_Generic.Get_Parameter_Value('TRANSFER_TRANS_LEGAL_CO_ID'))
294: and exists (select 'Y' from pay_assignment_actions paa
295: where paa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value('TRANSFER_PAYROLL_ACTION_ID')
296: and paa.tax_unit_id = ffaic2.context)
297: order by ffai3.value;
298:

Line 326: pay_assignment_actions paa,

322: ff_user_entities ffue,
323: ff_archive_items ffai,
324: pay_action_interlocks pai,
325: per_all_assignments_f paf,
326: pay_assignment_actions paa,
327: pay_payroll_actions ppa
328: where pai.locking_action_id = paa.assignment_action_id
329: and ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value
330: ('TRANSFER_PAYROLL_ACTION_ID')

Line 369: pay_assignment_actions paa,

365: ff_user_entities ffue,
366: ff_archive_items ffai,
367: pay_action_interlocks pai,
368: per_all_assignments_f paf,
369: pay_assignment_actions paa,
370: pay_payroll_actions ppa
371: where pai.locking_action_id = paa.assignment_action_id
372: and ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value
373: ('TRANSFER_PAYROLL_ACTION_ID')

Line 421: pay_assignment_actions paa,

417: ff_user_entities ffue,
418: ff_archive_items ffai,
419: pay_action_interlocks pai,
420: per_all_assignments_f paf,
421: pay_assignment_actions paa,
422: pay_payroll_actions ppa,
423: pay_us_states pus
424: where ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value
425: ('TRANSFER_PAYROLL_ACTION_ID')

Line 469: pay_assignment_actions paa,

465: ff_user_entities ffue,
466: ff_archive_items ffai,
467: pay_action_interlocks pai,
468: per_all_assignments_f paf,
469: pay_assignment_actions paa,
470: pay_payroll_actions ppa,
471: pay_us_states pus
472: where ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value
473: ('TRANSFER_PAYROLL_ACTION_ID')

Line 581: processor while the pay_assignment_actions looks for

577: --
578: --
579: /* Context and Parameter in the cursor are
580: Payroll_action_id table looks for value related to Year End pre-
581: processor while the pay_assignment_actions looks for
582: assignment actions of Mag. tapes
583: Context :
584: TAX_UNIT_ID - Submitter's Tax Unit ID
585: JURISDICTION_CODE - Set to Dummy Value as This is federal Cursor

Line 608: pay_assignment_actions AA

604: 'TRANSFER_EMP_CODE=P', 'R'
605: FROM
606: hr_all_organization_units hou,
607: pay_payroll_actions ppa,
608: pay_assignment_actions AA
609: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
610: ('TRANSFER_PAYROLL_ACTION_ID')
611: AND ppa.report_type = 'YREND'
612: AND to_char(ppa.effective_date,'YYYY') =

Line 636: pay_assignment_actions AA,

632: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
633: FROM per_all_people_f PE,
634: per_all_assignments_f SS,
635: pay_action_interlocks AI,
636: pay_assignment_actions AA,
637: pay_payroll_actions PA
638: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
639: ('TRANSFER_PAYROLL_ACTION_ID') AND
640: AA.payroll_action_id = PA.payroll_action_id AND