APPS.PAY_US_MAGW2_REPORTING dependencies on PAY_US_ARCH_MAG_COUNTY_V

Line 48: pay_us_arch_mag_county_v to pay_us_acrh_county_sd_v

44: ohstw2_supp to fix indiana and ohio
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

Line 318: FROM pay_us_arch_mag_county_v pcv

314: PSV.state_abbrev = 'IN' AND
315: ( NOT EXISTS
316: (
317: SELECT 'y'
318: FROM pay_us_arch_mag_county_v pcv
319: WHERE substr(pcv.jurisdiction_code,1,2) = substr(psv.jurisdiction_code,1,2) AND
320: pcv.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID')
321: )
322: OR (0 = (SELECT NVL(sum(W2_BOX_21),0)