[Home] [Help]
50: and also changed the state abbv in query from IN
51: to OH. This is changed for bug 969567
52: 24-oct-99 djoshi 40.8 changed the oh_in_employee cursor and
53: ohstw2_supp cursor to make them performant.
54: 22-NOV-99 ahanda 115.5 Took the 110.6 of r11 and made the fnd_date changes.
55:
56: 24-nov-00 djoshi 115.8 Modified the file for Indiana 'S' record ref. bug
57: 1230231.
58: 10-sep-00 djoshi 115.9 Modified the file for Indiana 'S' record
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,
201: SELECT DISTINCT 'PAYROLL_ACTION_ID=C', PA.payroll_action_id,
202: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
203: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
204: 'JURISDICTION_CODE=C', SR.jurisdiction_code,
205: 'DATE_EARNED=C' , fnd_date.date_to_canonical(PA.effective_date),
206: 'BUSINESS_GROUP_ID=C', PA.business_group_id
207: FROM pay_state_rules SR,
208: pay_payroll_actions PA,
209: pay_assignment_actions AA,
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,
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
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,
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
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
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