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_PAYROLL_ACTIONS

Line 158: pay_payroll_actions ppa, -- YREND Preprocessor

154: ff_contexts ffc,
155: ff_user_entities fue, -- A_US_1099R_TRANSMITTER_INDICATOR
156: ff_user_entities fue2, -- A_US_1099R_TRANSMITTER_CODE
157: ff_archive_item_contexts ffaic,
158: pay_payroll_actions ppa, -- YREND Preprocessor
159: pay_payroll_actions ppa2, -- 1099R Payroll Action Id
160: ff_archive_items fai, -- Transmitter Indicator
161: ff_archive_items fai2 -- Transmitter code
162: where ppa2.payroll_action_id

Line 159: pay_payroll_actions ppa2, -- 1099R Payroll Action Id

155: ff_user_entities fue, -- A_US_1099R_TRANSMITTER_INDICATOR
156: ff_user_entities fue2, -- A_US_1099R_TRANSMITTER_CODE
157: ff_archive_item_contexts ffaic,
158: pay_payroll_actions ppa, -- YREND Preprocessor
159: pay_payroll_actions ppa2, -- 1099R Payroll Action Id
160: ff_archive_items fai, -- Transmitter Indicator
161: ff_archive_items fai2 -- Transmitter code
162: where ppa2.payroll_action_id
163: = Pay_Magtape_Generic.Get_Parameter_Value('TRANSFER_PAYROLL_ACTION_ID')

Line 217: pay_payroll_actions ppa, -- YREND Preprocessor

213: ff_contexts ffc,
214: ff_user_entities fue, -- A_US_1099R_TRANSMITTER_INDICATOR
215: ff_user_entities fue2, -- A_US_1099R_TRANSMITTER_CODE
216: ff_archive_item_contexts ffaic,
217: pay_payroll_actions ppa, -- YREND Preprocessor
218: pay_payroll_actions ppa2, -- 1099R Payroll Action Id
219: ff_archive_items fai, -- INDICATOR
220: ff_archive_items fai2 -- Transmitter code
221: where ppa2.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value('TRANSFER_PAYROLL_ACTION_ID')

Line 218: pay_payroll_actions ppa2, -- 1099R Payroll Action Id

214: ff_user_entities fue, -- A_US_1099R_TRANSMITTER_INDICATOR
215: ff_user_entities fue2, -- A_US_1099R_TRANSMITTER_CODE
216: ff_archive_item_contexts ffaic,
217: pay_payroll_actions ppa, -- YREND Preprocessor
218: pay_payroll_actions ppa2, -- 1099R Payroll Action Id
219: ff_archive_items fai, -- INDICATOR
220: ff_archive_items fai2 -- Transmitter code
221: where ppa2.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value('TRANSFER_PAYROLL_ACTION_ID')
222: and ppa.report_type = 'YREND'

Line 278: pay_payroll_actions ppa,

274: ff_archive_items ffai2, -- Tax Unit Id
275: ff_archive_items ffai3, -- Tax Unit Name
276: ff_archive_item_contexts ffaic,
277: ff_archive_item_contexts ffaic2,
278: pay_payroll_actions ppa,
279: pay_payroll_actions ppa2
280: where ffai.context1 = Pay_Magtape_Generic.Get_Parameter_value('TRANSFER_YREND_PAY_ACT_ID')
281: and ffai.archive_item_id = ffaic.archive_item_id
282: and ffue.user_entity_id = ffai.user_entity_id

Line 279: pay_payroll_actions ppa2

275: ff_archive_items ffai3, -- Tax Unit Name
276: ff_archive_item_contexts ffaic,
277: ff_archive_item_contexts ffaic2,
278: pay_payroll_actions ppa,
279: pay_payroll_actions ppa2
280: where ffai.context1 = Pay_Magtape_Generic.Get_Parameter_value('TRANSFER_YREND_PAY_ACT_ID')
281: and ffai.archive_item_id = ffaic.archive_item_id
282: and ffue.user_entity_id = ffai.user_entity_id
283: and ffue.user_entity_name = 'A_US_1099R_TRANSMITTER_CODE'

Line 333: pay_payroll_actions ppa

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')
337: and ppa.payroll_action_id = paa.payroll_action_id

Line 376: pay_payroll_actions ppa

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')
380: and ppa.payroll_action_id = paa.payroll_action_id

Line 428: pay_payroll_actions ppa,

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')
432: and ppa.payroll_action_id = paa.payroll_action_id

Line 476: pay_payroll_actions ppa,

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')
480: and ppa.payroll_action_id = paa.payroll_action_id

Line 566: pay_payroll_actions PPA,

562: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY',
563: 'BUSINESS_GROUP_ID=C',PPA.business_group_id
564: FROM pay_state_rules SR,
565: hr_organization_information HOI,
566: pay_payroll_actions PPA,
567: pay_payroll_actions PPA1
568: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
569: ('TRANSFER_PAYROLL_ACTION_ID')
570: AND ppa1.effective_date = ppa.effective_date

Line 567: pay_payroll_actions PPA1

563: 'BUSINESS_GROUP_ID=C',PPA.business_group_id
564: FROM pay_state_rules SR,
565: hr_organization_information HOI,
566: pay_payroll_actions PPA,
567: pay_payroll_actions PPA1
568: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
569: ('TRANSFER_PAYROLL_ACTION_ID')
570: AND ppa1.effective_date = ppa.effective_date
571: AND ppa1.report_qualifier = sr.state_code

Line 618: pay_payroll_actions ppa,

614: 'TAX_UNIT_NAME=P' ,substr(hou.name,1,80), --Bug# 14286448 Gre length issue
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'

Line 648: pay_payroll_actions PA

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
652: AA.tax_unit_id = pay_magtape_generic.get_parameter_value