8225: WHERE customer_id = pn_cust_id
8226: AND address_id = pn_address_id;
8227:
8228: CURSOR cur_get_ser_type_vendor(
8229: cp_vendor_id IN Po_Headers_All.vendor_id%type,
8230: cp_vendor_site_id IN Po_Headers_All.vendor_site_id%type
8231: )
8232: IS
8233: SELECT service_type_code
8226: AND address_id = pn_address_id;
8227:
8228: CURSOR cur_get_ser_type_vendor(
8229: cp_vendor_id IN Po_Headers_All.vendor_id%type,
8230: cp_vendor_site_id IN Po_Headers_All.vendor_site_id%type
8231: )
8232: IS
8233: SELECT service_type_code
8234: FROM JAI_CMN_VENDOR_SITES