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

Line 161: ff_archive_items fai2 -- 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')
164: and ppa.report_type = 'YREND'
165: and ppa.effective_date = ppa2.effective_date

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

Line 220: ff_archive_items fai2 -- 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'
223: and ppa.effective_date = ppa2.effective_date
224: and ppa.business_group_id + 0 = ppa2.business_group_id

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

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

Line 273: ff_archive_items ffai, -- TCC

269: -- hr_organization_units hou,
270: ff_contexts ffc,
271: ff_user_entities ffue,
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,

Line 274: ff_archive_items ffai2, -- Tax Unit Id

270: ff_contexts ffc,
271: ff_user_entities ffue,
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,

Line 275: ff_archive_items ffai3, -- Tax Unit Name

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

Line 329: ff_archive_items ffai,

325: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
326: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,
327: per_all_people_f ppf,
328: ff_user_entities ffue,
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

Line 372: ff_archive_items ffai,

368: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
369: from pay_us_arch_mag_state_v pes, -- pay_us_emp_state_tax_rules_f pes,
370: per_all_people_f ppf,
371: ff_user_entities ffue,
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

Line 424: ff_archive_items ffai,

420: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
421: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,
422: per_all_people_f ppf,
423: ff_user_entities ffue,
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,

Line 472: ff_archive_items ffai,

468: 'TRANSFER_ASSIGNMENT_ACTION_ID=P' , pai.locked_action_id -- YREND Pre-Processor aaid
469: from pay_us_arch_mag_state_v pes, -- pay_us_emp_state_tax_rules_f pes,
470: per_all_people_f ppf,
471: ff_user_entities ffue,
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,