DBA Data[Home] [Help]

APPS.PAYUSUNB_PKG dependencies on PAY_US_CITY_TAX_INFO_F

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

1701: END fnc_sit_exists;
1702:
1703: /*************************************************************************
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.

Line 1724: FROM pay_us_city_tax_info_f

1720: /******************* 3005756 changes start *********************************/
1721:
1722: CURSOR c_check_city IS
1723: SELECT city_tax,school_tax
1724: FROM pay_us_city_tax_info_f
1725: WHERE jurisdiction_code = IN_jurisdiction
1726: AND IN_as_of_date BETWEEN effective_start_date AND effective_end_date;
1727:
1728: