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 300: and exists (select 'Y' from pay_assignment_actions paa

296: and ffai3.context1 = ffai2.context1
297: and ffaic2.context_id = ffc.context_id
298: and (Pay_Magtape_Generic.Get_Parameter_value('TRANSFER_ALL_PAYERS') = 'Y'
299: OR ffaic2.context = Pay_Magtape_Generic.Get_Parameter_Value('TRANSFER_TRANS_LEGAL_CO_ID'))
300: and exists (select 'Y' from pay_assignment_actions paa
301: where paa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value('TRANSFER_PAYROLL_ACTION_ID')
302: and paa.tax_unit_id = ffaic2.context)
303: order by ffai3.value;
304:

Line 332: pay_assignment_actions paa,

328: ff_user_entities ffue,
329: ff_archive_items ffai,
330: pay_action_interlocks pai,
331: per_all_assignments_f paf,
332: pay_assignment_actions paa,
333: pay_payroll_actions ppa
334: where pai.locking_action_id = paa.assignment_action_id
335: and ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value
336: ('TRANSFER_PAYROLL_ACTION_ID')

Line 375: pay_assignment_actions paa,

371: ff_user_entities ffue,
372: ff_archive_items ffai,
373: pay_action_interlocks pai,
374: per_all_assignments_f paf,
375: pay_assignment_actions paa,
376: pay_payroll_actions ppa
377: where pai.locking_action_id = paa.assignment_action_id
378: and ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value
379: ('TRANSFER_PAYROLL_ACTION_ID')

Line 427: pay_assignment_actions paa,

423: ff_user_entities ffue,
424: ff_archive_items ffai,
425: pay_action_interlocks pai,
426: per_all_assignments_f paf,
427: pay_assignment_actions paa,
428: pay_payroll_actions ppa,
429: pay_us_states pus
430: where ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value
431: ('TRANSFER_PAYROLL_ACTION_ID')

Line 475: pay_assignment_actions paa,

471: ff_user_entities ffue,
472: ff_archive_items ffai,
473: pay_action_interlocks pai,
474: per_all_assignments_f paf,
475: pay_assignment_actions paa,
476: pay_payroll_actions ppa,
477: pay_us_states pus
478: where ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value
479: ('TRANSFER_PAYROLL_ACTION_ID')

Line 592: processor while the pay_assignment_actions looks for

588: --
589: --
590: /* Context and Parameter in the cursor are
591: Payroll_action_id table looks for value related to Year End pre-
592: processor while the pay_assignment_actions looks for
593: assignment actions of Mag. tapes
594: Context :
595: TAX_UNIT_ID - Submitter's Tax Unit ID
596: JURISDICTION_CODE - Set to Dummy Value as This is federal Cursor

Line 619: pay_assignment_actions AA

615: 'TRANSFER_EMP_CODE=P', 'R'
616: FROM
617: hr_all_organization_units hou,
618: pay_payroll_actions ppa,
619: pay_assignment_actions AA
620: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
621: ('TRANSFER_PAYROLL_ACTION_ID')
622: AND ppa.report_type = 'YREND'
623: AND to_char(ppa.effective_date,'YYYY') =

Line 647: pay_assignment_actions AA,

643: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
644: FROM per_all_people_f PE,
645: per_all_assignments_f SS,
646: pay_action_interlocks AI,
647: pay_assignment_actions AA,
648: pay_payroll_actions PA
649: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
650: ('TRANSFER_PAYROLL_ACTION_ID') AND
651: AA.payroll_action_id = PA.payroll_action_id AND