DBA Data[Home] [Help]

APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_US_CITY_TAX_INFO_F

Line 2725: FROM pay_us_city_tax_info_f

2721: SELECT 'Y'
2722: INTO lv_update_prr
2723: FROM dual
2724: WHERE EXISTS (SELECT 0
2725: FROM pay_us_city_tax_info_f
2726: WHERE jurisdiction_code = main_old_juri_code)
2727: OR EXISTS (SELECT 0
2728: FROM pay_us_city_tax_info_f
2729: WHERE jurisdiction_code = main_new_juri_code)

Line 2728: FROM pay_us_city_tax_info_f

2724: WHERE EXISTS (SELECT 0
2725: FROM pay_us_city_tax_info_f
2726: WHERE jurisdiction_code = main_old_juri_code)
2727: OR EXISTS (SELECT 0
2728: FROM pay_us_city_tax_info_f
2729: WHERE jurisdiction_code = main_new_juri_code)
2730: OR length(main_old_juri_code) = 2 ;
2731: EXCEPTION
2732: WHEN NO_DATA_FOUND THEN