APPS.PAY_GTNLOD_PKG dependencies on PAY_US_COUNTIES

Line 634: ls_county_name pay_us_counties.county_name%TYPE := NULL;

630: END get_state_name;
631:
632: FUNCTION get_county_name(p_tax_type_code IN VARCHAR2, p_jurisdiction_code IN VARCHAR2)
633: RETURN VARCHAR2 IS
634: ls_county_name pay_us_counties.county_name%TYPE := NULL;
635: BEGIN
636: hr_utility.trace('GET_COUNTY_NAME called');
637: hr_utility.trace('p_tax_type_code : ' || p_tax_type_code || ' p_jurisdiction_code : ' || p_jurisdiction_code);
638: IF p_tax_type_code = 'COUNTY' THEN

Line 640: FROM pay_us_counties

636: hr_utility.trace('GET_COUNTY_NAME called');
637: hr_utility.trace('p_tax_type_code : ' || p_tax_type_code || ' p_jurisdiction_code : ' || p_jurisdiction_code);
638: IF p_tax_type_code = 'COUNTY' THEN
639: SELECT county_name INTO ls_county_name
640: FROM pay_us_counties
641: WHERE state_code = substr(p_jurisdiction_code,1,2)
642: AND county_code = substr(p_jurisdiction_code,4,3);
643:
644: END IF;