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
345: pay_us_states PUS,
346: pay_us_arch_mag_county_sd_v PMV,
347: pay_payroll_actions PA,
348: pay_assignment_actions AA
349:
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
370: pay_us_states PUS,
371: pay_us_arch_mag_city_sd_v PMC,
372: pay_assignment_actions AA,
373: pay_payroll_actions PA
374: WHERE
392: (PA.effective_date, AA.assignment_id)),
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