81: SELECT 'TAX_UNIT_ID=C' , HOI.organization_id,
82: 'JURISDICTION_CODE=C', SR.jurisdiction_code,
83: 'TRANSFER_JD=P', SR.jurisdiction_code,
84: 'ASSIGNMENT_ID=C' , '-1',
85: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
86: 'TRANSFER_HIGH_COUNT=P', '0',
87: 'TRANSFER_SCHOOL_DISTRICT=P', '-5',
88: 'TRANSFER_COUNTY=P', '-1',
89: 'TRANSFER_2678_FILER=P', HOI.org_information8,
177: SELECT
178: 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
179: 'ASSIGNMENT_ID=C', AA.assignment_id,
180: 'DATE_EARNED=C',
181: fnd_date.date_to_canonical(pay_magtape_generic.date_earned(PA.effective_date,
182: AA.assignment_id)),
183: 'JURISDICTION_CODE=C',
184: pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
185: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id