APPS.PAYUSUNB_PKG dependencies on PAY_US_COUNTY_TAX_INFO_F

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

1704: routine name: fnc_lit_tax_exists
1705: purpose: checks table pay_us_city_tax_info_f and return TRUE/FALSE
1706: based on value of column city_tax or school_tax flag
1707: depending on IN_lit string.
1708: IF IN_lit is 'COUNTY' then checks table pay_us_county_tax_info_f
1709: and return TRUE/FALSE based on value of column county_tax.
1710: parameters: IN_jurisdiction -
1711: IN_as_of_date -
1712: IN_lit - string contain 'CITY' or 'SCHOOL' or 'COUNTY'

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

1712: IN_lit - string contain 'CITY' or 'SCHOOL' or 'COUNTY'
1713: return: TRUE/FALSE
1714: specs:
1715: **************************************************************************/
1716: FUNCTION fnc_lit_tax_exists(IN_jurisdiction IN pay_us_county_tax_info_f.jurisdiction_code%TYPE,
1717: IN_as_of_date IN DATE,
1718: IN_lit IN VARCHAR2) RETURN BOOLEAN IS
1719:
1720: /******************* 3005756 changes start *********************************/

Line 1731: FROM pay_us_county_tax_info_f

1727:
1728:
1729: CURSOR c_check_county IS
1730: SELECT county_tax,school_tax
1731: FROM pay_us_county_tax_info_f
1732: WHERE jurisdiction_code = IN_jurisdiction
1733: AND IN_as_of_date BETWEEN effective_start_date AND effective_end_date;
1734:
1735: