APPS.PAY_US_1099R_MAG_REPORTING dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 157: ff_archive_item_contexts ffaic,

153: from hr_organization_information hoi,
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

Line 216: ff_archive_item_contexts ffaic,

212: pay_state_rules psr,
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

Line 276: ff_archive_item_contexts ffaic,

272: ff_user_entities ffue2,
273: ff_archive_items ffai, -- TCC
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')

Line 277: ff_archive_item_contexts ffaic2,

273: ff_archive_items ffai, -- TCC
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