APPS.PAYUSUNB_PKG dependencies on PAY_US_COUNTY_TAX_INFO_F

Line 1223: IF IN_lit is 'COUNTY' then checks table pay_us_county_tax_info_f

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.
1225: parameters: IN_jurisdiction -
1226: IN_as_of_date -
1227: IN_lit - string contain 'CITY' or 'SCHOOL' or 'COUNTY'

Line 1231: FUNCTION fnc_lit_tax_exists(IN_jurisdiction IN pay_us_county_tax_info_f.jurisdiction_code%TYPE,

1227: IN_lit - string contain 'CITY' or 'SCHOOL' or 'COUNTY'
1228: return: TRUE/FALSE
1229: specs:
1230: **************************************************************************/
1231: FUNCTION fnc_lit_tax_exists(IN_jurisdiction IN pay_us_county_tax_info_f.jurisdiction_code%TYPE,
1232: IN_as_of_date IN DATE,
1233: IN_lit IN VARCHAR2) RETURN BOOLEAN IS
1234:
1235: /******************* 3005756 changes start *********************************/

Line 1246: FROM pay_us_county_tax_info_f

1242:
1243:
1244: CURSOR c_check_county IS
1245: SELECT county_tax,school_tax
1246: FROM pay_us_county_tax_info_f
1247: WHERE jurisdiction_code = IN_jurisdiction
1248: AND IN_as_of_date BETWEEN effective_start_date AND effective_end_date;
1249:
1250: