[Home] [Help]
138: SELECT
139: VENDOR_NAME
140: INTO P_VENDOR_NAME
141: FROM
142: PO_VENDORS
143: WHERE VENDOR_ID = P_VENDOR_ID;
144: END IF;
145: IF (P_VENDOR_SITE IS NOT NULL) THEN
146: LP_VENDOR_SITE := 'and pvs.vendor_site_code = ''' || P_VENDOR_SITE || '''';