147: from hr_organization_information hoi,
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
206: pay_state_rules psr,
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
266: ff_user_entities ffue2,
267: ff_archive_items ffai, -- TCC
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')
267: ff_archive_items ffai, -- TCC
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