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 FF_ARCHIVE_ITEMS

Line 154: ff_archive_items fai, -- 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')
158: and ppa.report_type = 'YREND'

Line 155: ff_archive_items fai2 -- 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')
158: and ppa.report_type = 'YREND'
159: and ppa.effective_date = ppa2.effective_date

Line 213: ff_archive_items fai, -- 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'
217: and ppa.effective_date = ppa2.effective_date

Line 214: ff_archive_items fai2 -- 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'
217: and ppa.effective_date = ppa2.effective_date
218: and ppa.business_group_id + 0 = ppa2.business_group_id

Line 253: -- When we pull from ff_archive_items we have to make sure the context1 is the YREND archiver

249: -- Added an exists clause to check for the existance of an assignment action for
250: -- the Payer GRE. A GRE can be the transmitter without any employees. In that case
251: -- we don't want to print any payer records.
252: -- We have to have all the joins to ppa and ppa2 otherwise we will pick up duplicate rows.
253: -- When we pull from ff_archive_items we have to make sure the context1 is the YREND archiver
254: -- for the GRE othwerise we get duplicates.
255:
256: Cursor US_1099R_Payer is
257:

Line 267: ff_archive_items ffai, -- TCC

263: -- hr_organization_units hou,
264: ff_contexts ffc,
265: ff_user_entities ffue,
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,

Line 268: ff_archive_items ffai2, -- Tax Unit Id

264: ff_contexts ffc,
265: ff_user_entities ffue,
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,

Line 269: ff_archive_items ffai3, -- Tax Unit Name

265: ff_user_entities ffue,
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

Line 323: ff_archive_items ffai,

319: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
320: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,
321: per_all_people_f ppf,
322: ff_user_entities ffue,
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

Line 366: ff_archive_items ffai,

362: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
363: from pay_us_arch_mag_state_v pes, -- pay_us_emp_state_tax_rules_f pes,
364: per_all_people_f ppf,
365: ff_user_entities ffue,
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

Line 418: ff_archive_items ffai,

414: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
415: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,
416: per_all_people_f ppf,
417: ff_user_entities ffue,
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,

Line 466: ff_archive_items ffai,

462: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
463: from pay_us_arch_mag_state_v pes, -- pay_us_emp_state_tax_rules_f pes,
464: per_all_people_f ppf,
465: ff_user_entities ffue,
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,