794: -- if the JD passed is for County, City or School Dst
795: -- get the state abbrev and then use add it before the City Name
796: if substr(p_jurisdiction_code,4,3) <> '000' then
797: lv_jurisdiction_name
798: := pay_us_employee_payslip_web.get_jurisdiction_name(
799: substr(p_jurisdiction_code,1,2)||'-000-0000') || '-';
800: end if;
801:
802: lv_jurisdiction_name
800: end if;
801:
802: lv_jurisdiction_name
803: := lv_jurisdiction_name ||
804: pay_us_employee_payslip_web.get_jurisdiction_name(
805: p_jurisdiction_code);
806: end if;
807:
808: if p_resident_jurisdiction is not null then
807:
808: if p_resident_jurisdiction is not null then
809: lv_jurisdiction_name
810: := lv_jurisdiction_name || '/' ||
811: pay_us_employee_payslip_web.get_jurisdiction_name(
812: p_jurisdiction_code);
813: end if;
814:
815: return(lv_jurisdiction_name);