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_MAGW2_REPORTING dependencies on PAY_MAGTAPE_GENERIC

Line 91: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')

87: FROM pay_state_rules SR,
88: hr_organization_information HOI,
89: pay_payroll_actions PPA
90: WHERE HOI.organization_id =
91: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
92: AND SR.state_code =
93: pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
94: AND HOI.org_information_context = 'W2 Reporting Rules'
95: AND PPA.report_type = 'YREND'

Line 93: pay_magtape_generic.get_parameter_value('TRANSFER_STATE')

89: pay_payroll_actions PPA
90: WHERE HOI.organization_id =
91: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
92: AND SR.state_code =
93: pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
94: AND HOI.org_information_context = 'W2 Reporting Rules'
95: AND PPA.report_type = 'YREND'
96: AND HOI.ORGANIZATION_ID = substr(PPA.legislative_parameters,instr(PPA.legislative_parameters,'TRANSFER_GRE=') + length('TRANSFER_GRE='))
97: AND to_char(PPA.effective_date,'YYYY') =

Line 98: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')

94: AND HOI.org_information_context = 'W2 Reporting Rules'
95: AND PPA.report_type = 'YREND'
96: AND HOI.ORGANIZATION_ID = substr(PPA.legislative_parameters,instr(PPA.legislative_parameters,'TRANSFER_GRE=') + length('TRANSFER_GRE='))
97: AND to_char(PPA.effective_date,'YYYY') =
98: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')
99: AND to_char(PPA.effective_date,'DD-MM') = '31-12'
100: UNION ALL
101: SELECT 'TAX_UNIT_ID=C', HOI.organization_id,
102: 'JURISDICTION_CODE=C', 'DUMMY_VALUE',

Line 111: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')

107: 'PAYROLL_ACTION_ID=C',ppa.payroll_action_id -- payroll_action_id of YREND
108: FROM hr_organization_information HOI,
109: pay_payroll_actions PPA
110: WHERE HOI.organization_id =
111: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
112: AND pay_magtape_generic.get_parameter_value('TRANSFER_STATE') = 'FED'
113: AND HOI.org_information_context = 'W2 Reporting Rules'
114: AND PPA.report_type = 'YREND'
115: AND HOI.ORGANIZATION_ID = substr(PPA.legislative_parameters,instr(PPA.legislative_parameters,'TRANSFER_GRE=') + length('TRANSFER_GRE='))

Line 112: AND pay_magtape_generic.get_parameter_value('TRANSFER_STATE') = 'FED'

108: FROM hr_organization_information HOI,
109: pay_payroll_actions PPA
110: WHERE HOI.organization_id =
111: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
112: AND pay_magtape_generic.get_parameter_value('TRANSFER_STATE') = 'FED'
113: AND HOI.org_information_context = 'W2 Reporting Rules'
114: AND PPA.report_type = 'YREND'
115: AND HOI.ORGANIZATION_ID = substr(PPA.legislative_parameters,instr(PPA.legislative_parameters,'TRANSFER_GRE=') + length('TRANSFER_GRE='))
116: AND to_char(PPA.effective_date,'YYYY') =

Line 117: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')

113: AND HOI.org_information_context = 'W2 Reporting Rules'
114: AND PPA.report_type = 'YREND'
115: AND HOI.ORGANIZATION_ID = substr(PPA.legislative_parameters,instr(PPA.legislative_parameters,'TRANSFER_GRE=') + length('TRANSFER_GRE='))
116: AND to_char(PPA.effective_date,'YYYY') =
117: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')
118: AND to_char(PPA.effective_date,'DD-MM') = '31-12';
119:
120: --
121: -- Used by Magnetic W2 (TIB4 format).

Line 140: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value

136: ff_contexts ffc,
137: ff_database_items fdi,
138: pay_payroll_actions ppa,
139: pay_assignment_actions AA
140: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
141: ('TRANSFER_PAYROLL_ACTION_ID')
142: AND ppa.report_type = 'YREND'
143: AND to_char(ppa.effective_date,'YYYY') =
144: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')

Line 144: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')

140: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
141: ('TRANSFER_PAYROLL_ACTION_ID')
142: AND ppa.report_type = 'YREND'
143: AND to_char(ppa.effective_date,'YYYY') =
144: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')
145: AND to_char(ppa.effective_date,'DD-MM') = '31-12'
146: AND AA.tax_unit_id = substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'TRANSFER_GRE=') + length('TRANSFER_GRE='))
147: AND fdi.user_name = 'A_TAX_UNIT_NAME'
148: AND ffc.context_name = 'TAX_UNIT_ID'

Line 168: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned

164:
165: CURSOR magw2_employee IS
166: SELECT 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
167: 'ASSIGNMENT_ID=C', AA.assignment_id,
168: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
169: (PA.effective_date, AA.assignment_id))
170: FROM per_people_f PE,
171: per_assignments_f SS,
172: pay_action_interlocks AI,

Line 175: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

171: per_assignments_f SS,
172: pay_action_interlocks AI,
173: pay_assignment_actions AA,
174: pay_payroll_actions PA
175: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
176: ('TRANSFER_PAYROLL_ACTION_ID') AND
177: AA.payroll_action_id = PA.payroll_action_id AND
178: AA.tax_unit_id = pay_magtape_generic.get_parameter_value
179: ('TAX_UNIT_ID') AND

Line 178: AA.tax_unit_id = pay_magtape_generic.get_parameter_value

174: pay_payroll_actions PA
175: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
176: ('TRANSFER_PAYROLL_ACTION_ID') AND
177: AA.payroll_action_id = PA.payroll_action_id AND
178: AA.tax_unit_id = pay_magtape_generic.get_parameter_value
179: ('TAX_UNIT_ID') AND
180: AI.locking_action_id = AA.assignment_action_id AND
181: SS.assignment_id = AA.assignment_id AND
182: PE.person_id = SS.person_id AND

Line 183: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN

179: ('TAX_UNIT_ID') AND
180: AI.locking_action_id = AA.assignment_action_id AND
181: SS.assignment_id = AA.assignment_id AND
182: PE.person_id = SS.person_id AND
183: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN
184: SS.effective_start_date and SS.effective_end_date AND
185: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN
186: PE.effective_start_date and PE.effective_end_date
187: ORDER BY PE.last_name, PE.first_name, PE.middle_names;

Line 185: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN

181: SS.assignment_id = AA.assignment_id AND
182: PE.person_id = SS.person_id AND
183: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN
184: SS.effective_start_date and SS.effective_end_date AND
185: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN
186: PE.effective_start_date and PE.effective_end_date
187: ORDER BY PE.last_name, PE.first_name, PE.middle_names;
188:
189: --

Line 211: WHERE PA1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

207: FROM pay_state_rules SR,
208: pay_payroll_actions PA,
209: pay_assignment_actions AA,
210: pay_payroll_actions PA1
211: WHERE PA1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
212: AND AA.payroll_action_id = pay_magtape_generic.get_parameter_value
213: ('TRANSFER_PAYROLL_ACTION_ID')
214: AND AA.serial_number IS NULL
215: AND PA.report_type = 'YREND'

Line 212: AND AA.payroll_action_id = pay_magtape_generic.get_parameter_value

208: pay_payroll_actions PA,
209: pay_assignment_actions AA,
210: pay_payroll_actions PA1
211: WHERE PA1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
212: AND AA.payroll_action_id = pay_magtape_generic.get_parameter_value
213: ('TRANSFER_PAYROLL_ACTION_ID')
214: AND AA.serial_number IS NULL
215: AND PA.report_type = 'YREND'
216: AND AA.tax_unit_id = substr(PA.legislative_parameters,instr(PA.legislative_parameters,'TRANSFER_GRE=') + length('TRANSFER_GRE='))

Line 218: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')

214: AND AA.serial_number IS NULL
215: AND PA.report_type = 'YREND'
216: AND AA.tax_unit_id = substr(PA.legislative_parameters,instr(PA.legislative_parameters,'TRANSFER_GRE=') + length('TRANSFER_GRE='))
217: AND to_char(PA.effective_date,'YYYY') =
218: pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR')
219: AND to_char(PA.effective_date,'DD-MM') = '31-12'
220: AND SR.state_code = ltrim(rtrim(PA1.report_qualifier));
221:
222: --

Line 229: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned

225:
226: CURSOR st_magw2_employee IS
227: SELECT 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id,
228: 'ASSIGNMENT_ID=C', AA.assignment_id,
229: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
230: (PA.effective_date, AA.assignment_id)),
231: 'JURISDICTION_CODE=C', SR.jurisdiction_code
232: FROM per_people_f PE,
233: per_assignments_f SS,

Line 238: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

234: pay_state_rules SR,
235: pay_action_interlocks AI,
236: pay_assignment_actions AA,
237: pay_payroll_actions PA
238: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
239: ('TRANSFER_PAYROLL_ACTION_ID') AND
240: AA.payroll_action_id = PA.payroll_action_id AND
241: AA.tax_unit_id = pay_magtape_generic.get_parameter_value
242: ('TAX_UNIT_ID') AND

Line 241: AA.tax_unit_id = pay_magtape_generic.get_parameter_value

237: pay_payroll_actions PA
238: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
239: ('TRANSFER_PAYROLL_ACTION_ID') AND
240: AA.payroll_action_id = PA.payroll_action_id AND
241: AA.tax_unit_id = pay_magtape_generic.get_parameter_value
242: ('TAX_UNIT_ID') AND
243: AI.locking_action_id = AA.assignment_action_id AND
244: AA.serial_number IS NULL AND
245: SR.state_code = ltrim(rtrim(PA.report_qualifier)) AND

Line 248: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN

244: AA.serial_number IS NULL AND
245: SR.state_code = ltrim(rtrim(PA.report_qualifier)) AND
246: SS.assignment_id = AA.assignment_id AND
247: PE.person_id = SS.person_id AND
248: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN
249: SS.effective_start_date AND SS.effective_end_date AND
250: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN
251: PE.effective_start_date AND PE.effective_end_date
252: ORDER BY PE.last_name, PE.first_name, PE.middle_names;

Line 250: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN

246: SS.assignment_id = AA.assignment_id AND
247: PE.person_id = SS.person_id AND
248: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN
249: SS.effective_start_date AND SS.effective_end_date AND
250: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN
251: PE.effective_start_date AND PE.effective_end_date
252: ORDER BY PE.last_name, PE.first_name, PE.middle_names;
253:
254: --

Line 260: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned

256: CURSOR oh_in_employee IS
257: SELECT 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id,
258: 'ASSIGNMENT_ACTION_ID=P', AI.locking_action_id,
259: 'ASSIGNMENT_ID=C', AA.assignment_id,
260: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
261: (PA.effective_date, AA.assignment_id)),
262: 'YREND_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id,
263: 'YREND_ASSIGNMENT_ID=P',AA.assignment_id,
264: 'DATE_EARNED=P', fnd_date.date_to_canonical(pay_magtape_generic.date_earned

Line 264: 'DATE_EARNED=P', fnd_date.date_to_canonical(pay_magtape_generic.date_earned

260: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
261: (PA.effective_date, AA.assignment_id)),
262: 'YREND_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id,
263: 'YREND_ASSIGNMENT_ID=P',AA.assignment_id,
264: 'DATE_EARNED=P', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
265: (PA.effective_date, AA.assignment_id))
266: FROM per_people_f PE,
267: per_assignments_f SS,
268: pay_action_interlocks AI,

Line 271: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

267: per_assignments_f SS,
268: pay_action_interlocks AI,
269: pay_assignment_actions AA,
270: pay_payroll_actions PA
271: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
272: ('TRANSFER_PAYROLL_ACTION_ID') AND
273: AA.payroll_action_id = PA.payroll_action_id AND
274: AA.tax_unit_id = pay_magtape_generic.get_parameter_value
275: ('TAX_UNIT_ID') AND

Line 274: AA.tax_unit_id = pay_magtape_generic.get_parameter_value

270: pay_payroll_actions PA
271: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
272: ('TRANSFER_PAYROLL_ACTION_ID') AND
273: AA.payroll_action_id = PA.payroll_action_id AND
274: AA.tax_unit_id = pay_magtape_generic.get_parameter_value
275: ('TAX_UNIT_ID') AND
276: AI.locking_action_id = AA.assignment_action_id AND
277: AA.serial_number IS NULL AND
278: SS.assignment_id = AA.assignment_id AND

Line 280: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN

276: AI.locking_action_id = AA.assignment_action_id AND
277: AA.serial_number IS NULL AND
278: SS.assignment_id = AA.assignment_id AND
279: PE.person_id = SS.person_id AND
280: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN
281: SS.effective_start_date AND SS.effective_end_date AND
282: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN
283: PE.effective_start_date AND PE.effective_end_date
284: ORDER BY PE.last_name, PE.first_name, PE.middle_names;

Line 282: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN

278: SS.assignment_id = AA.assignment_id AND
279: PE.person_id = SS.person_id AND
280: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN
281: SS.effective_start_date AND SS.effective_end_date AND
282: pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id) BETWEEN
283: PE.effective_start_date AND PE.effective_end_date
284: ORDER BY PE.last_name, PE.first_name, PE.middle_names;
285:
286:

Line 290: SELECT 'TRANSFER_ASS_ACTION_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),

286:
287:
288: CURSOR instw2_supp
289: IS
290: SELECT 'TRANSFER_ASS_ACTION_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),
291: 'ASSIGNMENT_ACTION_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),
292: 'ASSIGNMENT_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ID'),
293: 'DATE_EARNED=C', pay_magtape_generic.get_parameter_value('DATE_EARNED'),
294: 'TRANSFER_COUNTY=P', substr(PLV.jurisdiction,4,3),

Line 291: 'ASSIGNMENT_ACTION_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),

287:
288: CURSOR instw2_supp
289: IS
290: SELECT 'TRANSFER_ASS_ACTION_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),
291: 'ASSIGNMENT_ACTION_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),
292: 'ASSIGNMENT_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ID'),
293: 'DATE_EARNED=C', pay_magtape_generic.get_parameter_value('DATE_EARNED'),
294: 'TRANSFER_COUNTY=P', substr(PLV.jurisdiction,4,3),
295: 'JURISDICTION_CODE=C', PLV.jurisdiction

Line 292: 'ASSIGNMENT_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ID'),

288: CURSOR instw2_supp
289: IS
290: SELECT 'TRANSFER_ASS_ACTION_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),
291: 'ASSIGNMENT_ACTION_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),
292: 'ASSIGNMENT_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ID'),
293: 'DATE_EARNED=C', pay_magtape_generic.get_parameter_value('DATE_EARNED'),
294: 'TRANSFER_COUNTY=P', substr(PLV.jurisdiction,4,3),
295: 'JURISDICTION_CODE=C', PLV.jurisdiction
296: FROM pay_us_w2_locality_v plv

Line 293: 'DATE_EARNED=C', pay_magtape_generic.get_parameter_value('DATE_EARNED'),

289: IS
290: SELECT 'TRANSFER_ASS_ACTION_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),
291: 'ASSIGNMENT_ACTION_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),
292: 'ASSIGNMENT_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ID'),
293: 'DATE_EARNED=C', pay_magtape_generic.get_parameter_value('DATE_EARNED'),
294: 'TRANSFER_COUNTY=P', substr(PLV.jurisdiction,4,3),
295: 'JURISDICTION_CODE=C', PLV.jurisdiction
296: FROM pay_us_w2_locality_v plv
297: where plv.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID')

Line 297: where plv.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID')

293: 'DATE_EARNED=C', pay_magtape_generic.get_parameter_value('DATE_EARNED'),
294: 'TRANSFER_COUNTY=P', substr(PLV.jurisdiction,4,3),
295: 'JURISDICTION_CODE=C', PLV.jurisdiction
296: FROM pay_us_w2_locality_v plv
297: where plv.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID')
298: and plv.TAX_UNIT_ID = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
299: and plv.tax_type = 'COUNTY'
300: and plv.state_abbrev = 'IN'
301: and W2_BOX_21 > 0

Line 298: and plv.TAX_UNIT_ID = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')

294: 'TRANSFER_COUNTY=P', substr(PLV.jurisdiction,4,3),
295: 'JURISDICTION_CODE=C', PLV.jurisdiction
296: FROM pay_us_w2_locality_v plv
297: where plv.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID')
298: and plv.TAX_UNIT_ID = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
299: and plv.tax_type = 'COUNTY'
300: and plv.state_abbrev = 'IN'
301: and W2_BOX_21 > 0
302:

Line 305: SELECT 'TRANSFER_ASS_ACTION_ID=C',pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),

301: and W2_BOX_21 > 0
302:
303: UNION ALL
304:
305: SELECT 'TRANSFER_ASS_ACTION_ID=C',pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),
306: 'ASSIGNMENT_ACTION_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),
307: 'ASSIGNMENT_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ID'),
308: 'DATE_EARNED=C',pay_magtape_generic.get_parameter_value('DATE_EARNED'),
309: 'TRANSFER_COUNTY=P', '-1',

Line 306: 'ASSIGNMENT_ACTION_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),

302:
303: UNION ALL
304:
305: SELECT 'TRANSFER_ASS_ACTION_ID=C',pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),
306: 'ASSIGNMENT_ACTION_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),
307: 'ASSIGNMENT_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ID'),
308: 'DATE_EARNED=C',pay_magtape_generic.get_parameter_value('DATE_EARNED'),
309: 'TRANSFER_COUNTY=P', '-1',
310: 'JURISDICTION_CODE=C',psv.jurisdiction_code

Line 307: 'ASSIGNMENT_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ID'),

303: UNION ALL
304:
305: SELECT 'TRANSFER_ASS_ACTION_ID=C',pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),
306: 'ASSIGNMENT_ACTION_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),
307: 'ASSIGNMENT_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ID'),
308: 'DATE_EARNED=C',pay_magtape_generic.get_parameter_value('DATE_EARNED'),
309: 'TRANSFER_COUNTY=P', '-1',
310: 'JURISDICTION_CODE=C',psv.jurisdiction_code
311: FROM pay_us_arch_mag_state_v PSV

Line 308: 'DATE_EARNED=C',pay_magtape_generic.get_parameter_value('DATE_EARNED'),

304:
305: SELECT 'TRANSFER_ASS_ACTION_ID=C',pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),
306: 'ASSIGNMENT_ACTION_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID'),
307: 'ASSIGNMENT_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ID'),
308: 'DATE_EARNED=C',pay_magtape_generic.get_parameter_value('DATE_EARNED'),
309: 'TRANSFER_COUNTY=P', '-1',
310: 'JURISDICTION_CODE=C',psv.jurisdiction_code
311: FROM pay_us_arch_mag_state_v PSV
312: WHERE

Line 313: PSV.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID') AND

309: 'TRANSFER_COUNTY=P', '-1',
310: 'JURISDICTION_CODE=C',psv.jurisdiction_code
311: FROM pay_us_arch_mag_state_v PSV
312: WHERE
313: PSV.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID') AND
314: PSV.state_abbrev = 'IN' AND
315: ( NOT EXISTS
316: (
317: SELECT 'y'

Line 320: pcv.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID')

316: (
317: SELECT 'y'
318: FROM pay_us_arch_mag_county_v pcv
319: WHERE substr(pcv.jurisdiction_code,1,2) = substr(psv.jurisdiction_code,1,2) AND
320: pcv.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID')
321: )
322: OR (0 = (SELECT NVL(sum(W2_BOX_21),0)
323: FROM pay_us_w2_locality_v plv
324: WHERE plv.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID')

Line 324: WHERE plv.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID')

320: pcv.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID')
321: )
322: OR (0 = (SELECT NVL(sum(W2_BOX_21),0)
323: FROM pay_us_w2_locality_v plv
324: WHERE plv.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID')
325: AND plv.TAX_UNIT_ID = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
326: AND plv.tax_type = 'COUNTY'
327: AND plv.state_abbrev = 'IN'
328: AND substr(plv.jurisdiction,1,2) = substr(PSV.jurisdiction_code,1,2)

Line 325: AND plv.TAX_UNIT_ID = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')

321: )
322: OR (0 = (SELECT NVL(sum(W2_BOX_21),0)
323: FROM pay_us_w2_locality_v plv
324: WHERE plv.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID')
325: AND plv.TAX_UNIT_ID = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
326: AND plv.tax_type = 'COUNTY'
327: AND plv.state_abbrev = 'IN'
328: AND substr(plv.jurisdiction,1,2) = substr(PSV.jurisdiction_code,1,2)
329: )

Line 340: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned

336:
337: CURSOR ohstw2_supp IS
338: SELECT 'ASSIGNMENT_ACTION_ID=C', AA.assignment_action_id,
339: 'ASSIGNMENT_ID=C', AA.assignment_id,
340: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
341: (PA.effective_date, AA.assignment_id)),
342: 'TRANSFER_SCHOOL_DISTRICT=P',substr(PMV.jurisdiction_code,4,5),
343: 'JURISDICTION_CODE=C', PMV.jurisdiction_code
344: FROM

Line 351: AA.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID') AND

347: pay_payroll_actions PA,
348: pay_assignment_actions AA
349:
350: WHERE
351: AA.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID') AND
352: AA.payroll_action_id = PA.payroll_action_id AND
353: AA.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID') AND
354: PMV.assignment_action_id = AA.assignment_action_id AND
355: substr(PMV.jurisdiction_code,1,2) = pus.state_code AND

Line 353: AA.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID') AND

349:
350: WHERE
351: AA.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID') AND
352: AA.payroll_action_id = PA.payroll_action_id AND
353: AA.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID') AND
354: PMV.assignment_action_id = AA.assignment_action_id AND
355: substr(PMV.jurisdiction_code,1,2) = pus.state_code AND
356: pus.state_abbrev = 'OH'
357: AND (EXISTS(

Line 365: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned

361: aa.tax_unit_id,pmv.jurisdiction_code,8) > 0))
362: UNION ALL
363: SELECT 'ASSIGNMENT_ACTION_ID=C', AA.assignment_action_id,
364: 'ASSIGNMENT_ID=C', AA.assignment_id,
365: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
366: (PA.effective_date, AA.assignment_id)),
367: 'TRANSFER_SCHOOL_DISTRICT=P', substr(PMC.jurisdiction_code,4,5),
368: 'JURISDICTION_CODE=C', PMC.jurisdiction_code
369: FROM

Line 376: AA.assignment_action_id = pay_magtape_generic.get_parameter_value

372: pay_assignment_actions AA,
373: pay_payroll_actions PA
374: WHERE
375:
376: AA.assignment_action_id = pay_magtape_generic.get_parameter_value
377: ('YREND_ASSIGNMENT_ACTION_ID') AND
378: AA.payroll_action_id = PA.payroll_action_id AND
379: AA.tax_unit_id = pay_magtape_generic.get_parameter_value ('TAX_UNIT_ID') AND
380: PMC.assignment_action_id = AA.assignment_action_id AND

Line 379: AA.tax_unit_id = pay_magtape_generic.get_parameter_value ('TAX_UNIT_ID') AND

375:
376: AA.assignment_action_id = pay_magtape_generic.get_parameter_value
377: ('YREND_ASSIGNMENT_ACTION_ID') AND
378: AA.payroll_action_id = PA.payroll_action_id AND
379: AA.tax_unit_id = pay_magtape_generic.get_parameter_value ('TAX_UNIT_ID') AND
380: PMC.assignment_action_id = AA.assignment_action_id AND
381: substr(PMC.jurisdiction_code,1,2) = PUS.state_code AND
382: PUS.state_abbrev = 'OH'
383: AND (EXISTS(

Line 391: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned

387: aa.tax_unit_id,pmc.jurisdiction_code,8) > 0))
388: UNION ALL
389: SELECT 'ASSIGNMENT_ACTION_ID=C', AA.assignment_action_id,
390: 'ASSIGNMENT_ID=C', AA.assignment_id,
391: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
392: (PA.effective_date, AA.assignment_id)),
393: 'TRANSFER_SCHOOL_DISTRICT=P', '-1',
394: 'JURISDICTION_CODE=C', PSV.jurisdiction_code
395: FROM

Line 401: AA.assignment_action_id = pay_magtape_generic.get_parameter_value

397: pay_us_arch_mag_state_v PSV,
398: pay_assignment_actions AA,
399: pay_payroll_actions PA
400: WHERE
401: AA.assignment_action_id = pay_magtape_generic.get_parameter_value
402: ('YREND_ASSIGNMENT_ACTION_ID') AND
403: AA.payroll_action_id = PA.payroll_action_id AND
404: AA.tax_unit_id = pay_magtape_generic.get_parameter_value ('TAX_UNIT_ID') AND
405: PSV.assignment_action_id = AA.assignment_action_id AND

Line 404: AA.tax_unit_id = pay_magtape_generic.get_parameter_value ('TAX_UNIT_ID') AND

400: WHERE
401: AA.assignment_action_id = pay_magtape_generic.get_parameter_value
402: ('YREND_ASSIGNMENT_ACTION_ID') AND
403: AA.payroll_action_id = PA.payroll_action_id AND
404: AA.tax_unit_id = pay_magtape_generic.get_parameter_value ('TAX_UNIT_ID') AND
405: PSV.assignment_action_id = AA.assignment_action_id AND
406: substr(PSV.jurisdiction_code,1,2) = PUS.state_code AND
407: PUS.state_abbrev = 'OH'
408: AND (

Line 413: and plv.TAX_UNIT_ID = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')

409: ( 0 =
410: (SELECT nvl(sum(W2_BOX_21),0)
411: FROM pay_us_w2_locality_v plv
412: where plv.assignment_action_id = AA.assignment_action_id
413: and plv.TAX_UNIT_ID = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
414: and plv.tax_type = 'COUNTY SCHOOL'
415: and plv.state_abbrev = 'OH'
416: and substr(plv.jurisdiction,1,2) = substr(PSV.jurisdiction_code,1,2)))
417: or ( 0 =

Line 421: and plv.TAX_UNIT_ID = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')

417: or ( 0 =
418: (SELECT nvl(sum(W2_BOX_21),0)
419: FROM pay_us_w2_locality_v plv
420: where plv.assignment_action_id = AA.assignment_action_id
421: and plv.TAX_UNIT_ID = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
422: and plv.tax_type = 'CITY SCHOOL'
423: and plv.state_abbrev = 'OH'
424: and substr(plv.jurisdiction,1,2) = substr(PSV.jurisdiction_code,1,2)))
425: )

Line 440: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value

436: per_assignments_f paf,
437: pay_assignment_actions paa,
438: hr_tax_units_v tuv,
439: pay_payroll_actions ppa
440: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
441: ('TRANSFER_PAYROLL_ACTION_ID') AND
442: paa.payroll_action_id = ppa.payroll_action_id AND
443: paa.tax_unit_id = tuv.tax_unit_id and
444: paa.assignment_id = paf.assignment_id AND