DBA Data[Home] [Help]

APPS.PAYUSUNB_PKG dependencies on PAY_US_CITY_TAX_INFO_F

Line 1220: purpose: checks table pay_us_city_tax_info_f and return TRUE/FALSE

1216: END fnc_sit_exists;
1217:
1218: /*************************************************************************
1219: routine name: fnc_lit_tax_exists
1220: purpose: checks table pay_us_city_tax_info_f and return TRUE/FALSE
1221: based on value of column city_tax or school_tax flag
1222: depending on IN_lit string.
1223: IF IN_lit is 'COUNTY' then checks table pay_us_county_tax_info_f
1224: and return TRUE/FALSE based on value of column county_tax.

Line 1239: FROM pay_us_city_tax_info_f

1235: /******************* 3005756 changes start *********************************/
1236:
1237: CURSOR c_check_city IS
1238: SELECT city_tax,school_tax
1239: FROM pay_us_city_tax_info_f
1240: WHERE jurisdiction_code = IN_jurisdiction
1241: AND IN_as_of_date BETWEEN effective_start_date AND effective_end_date;
1242:
1243: