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
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
393: 'TRANSFER_SCHOOL_DISTRICT=P', '-1',
394: 'JURISDICTION_CODE=C', PSV.jurisdiction_code
395: FROM
396: pay_us_states PUS,
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