APPS.PAY_US_MAGW2_REPORTING dependencies on PAY_US_ARCH_MAG_CITY_SD_V

Line 49: pay_us_arch_mag_city_v to pay_us_arch_mag_city_sd_v

45:
46: 26-jan-99 VMehta 40.6 Modified w2_high_comp to change
47: 24-aug-99 djoshi 40.7 Modified ohstw2 to change the table
48: pay_us_arch_mag_county_v to pay_us_acrh_county_sd_v
49: pay_us_arch_mag_city_v to pay_us_arch_mag_city_sd_v
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.

Line 371: pay_us_arch_mag_city_sd_v PMC,

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
375: