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 152: pay_payroll_actions ppa, -- YREND Preprocessor

148: ff_contexts ffc,
149: ff_user_entities fue, -- A_US_1099R_TRANSMITTER_INDICATOR
150: ff_user_entities fue2, -- A_US_1099R_TRANSMITTER_CODE
151: ff_archive_item_contexts ffaic,
152: pay_payroll_actions ppa, -- YREND Preprocessor
153: pay_payroll_actions ppa2, -- 1099R Payroll Action Id
154: ff_archive_items fai, -- Transmitter Indicator
155: ff_archive_items fai2 -- Transmitter code
156: where ppa2.payroll_action_id

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

149: ff_user_entities fue, -- A_US_1099R_TRANSMITTER_INDICATOR
150: ff_user_entities fue2, -- A_US_1099R_TRANSMITTER_CODE
151: ff_archive_item_contexts ffaic,
152: pay_payroll_actions ppa, -- YREND Preprocessor
153: pay_payroll_actions ppa2, -- 1099R Payroll Action Id
154: ff_archive_items fai, -- Transmitter Indicator
155: ff_archive_items fai2 -- Transmitter code
156: where ppa2.payroll_action_id
157: = Pay_Magtape_Generic.Get_Parameter_Value('TRANSFER_PAYROLL_ACTION_ID')

Line 211: pay_payroll_actions ppa, -- YREND Preprocessor

207: ff_contexts ffc,
208: ff_user_entities fue, -- A_US_1099R_TRANSMITTER_INDICATOR
209: ff_user_entities fue2, -- A_US_1099R_TRANSMITTER_CODE
210: ff_archive_item_contexts ffaic,
211: pay_payroll_actions ppa, -- YREND Preprocessor
212: pay_payroll_actions ppa2, -- 1099R Payroll Action Id
213: ff_archive_items fai, -- INDICATOR
214: ff_archive_items fai2 -- Transmitter code
215: where ppa2.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value('TRANSFER_PAYROLL_ACTION_ID')

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

208: ff_user_entities fue, -- A_US_1099R_TRANSMITTER_INDICATOR
209: ff_user_entities fue2, -- A_US_1099R_TRANSMITTER_CODE
210: ff_archive_item_contexts ffaic,
211: pay_payroll_actions ppa, -- YREND Preprocessor
212: pay_payroll_actions ppa2, -- 1099R Payroll Action Id
213: ff_archive_items fai, -- INDICATOR
214: ff_archive_items fai2 -- Transmitter code
215: where ppa2.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value('TRANSFER_PAYROLL_ACTION_ID')
216: and ppa.report_type = 'YREND'

Line 272: pay_payroll_actions ppa,

268: ff_archive_items ffai2, -- Tax Unit Id
269: ff_archive_items ffai3, -- Tax Unit Name
270: ff_archive_item_contexts ffaic,
271: ff_archive_item_contexts ffaic2,
272: pay_payroll_actions ppa,
273: pay_payroll_actions ppa2
274: where ffai.context1 = Pay_Magtape_Generic.Get_Parameter_value('TRANSFER_YREND_PAY_ACT_ID')
275: and ffai.archive_item_id = ffaic.archive_item_id
276: and ffue.user_entity_id = ffai.user_entity_id

Line 273: pay_payroll_actions ppa2

269: ff_archive_items ffai3, -- Tax Unit Name
270: ff_archive_item_contexts ffaic,
271: ff_archive_item_contexts ffaic2,
272: pay_payroll_actions ppa,
273: pay_payroll_actions ppa2
274: where ffai.context1 = Pay_Magtape_Generic.Get_Parameter_value('TRANSFER_YREND_PAY_ACT_ID')
275: and ffai.archive_item_id = ffaic.archive_item_id
276: and ffue.user_entity_id = ffai.user_entity_id
277: and ffue.user_entity_name = 'A_US_1099R_TRANSMITTER_CODE'

Line 327: pay_payroll_actions ppa

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

Line 370: pay_payroll_actions ppa

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

Line 422: pay_payroll_actions ppa,

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

Line 470: pay_payroll_actions ppa,

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

Line 555: pay_payroll_actions PPA,

551: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY',
552: 'BUSINESS_GROUP_ID=C',PPA.business_group_id
553: FROM pay_state_rules SR,
554: hr_organization_information HOI,
555: pay_payroll_actions PPA,
556: pay_payroll_actions PPA1
557: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
558: ('TRANSFER_PAYROLL_ACTION_ID')
559: AND ppa1.effective_date = ppa.effective_date

Line 556: pay_payroll_actions PPA1

552: 'BUSINESS_GROUP_ID=C',PPA.business_group_id
553: FROM pay_state_rules SR,
554: hr_organization_information HOI,
555: pay_payroll_actions PPA,
556: pay_payroll_actions PPA1
557: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
558: ('TRANSFER_PAYROLL_ACTION_ID')
559: AND ppa1.effective_date = ppa.effective_date
560: AND ppa1.report_qualifier = sr.state_code

Line 607: pay_payroll_actions ppa,

603: 'TAX_UNIT_NAME=P' , hou.name,
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'

Line 637: pay_payroll_actions PA

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