DBA Data[Home] [Help]

APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_US_CITY_TAX_INFO_F

Line 3018: FROM pay_us_city_tax_info_f

3014: SELECT 'Y'
3015: INTO lv_update_prr
3016: FROM dual
3017: WHERE EXISTS (SELECT 0
3018: FROM pay_us_city_tax_info_f
3019: WHERE jurisdiction_code = main_old_juri_code)
3020: OR EXISTS (SELECT 0
3021: FROM pay_us_city_tax_info_f
3022: WHERE jurisdiction_code = main_new_juri_code)

Line 3021: FROM pay_us_city_tax_info_f

3017: WHERE EXISTS (SELECT 0
3018: FROM pay_us_city_tax_info_f
3019: WHERE jurisdiction_code = main_old_juri_code)
3020: OR EXISTS (SELECT 0
3021: FROM pay_us_city_tax_info_f
3022: WHERE jurisdiction_code = main_new_juri_code)
3023: OR length(main_old_juri_code) = 2 ;
3024: EXCEPTION
3025: WHEN NO_DATA_FOUND THEN