APPS.FA_FASINSVR_XMLP_PKG dependencies on PO_VENDORS

Line 119: FROM po_vendors

115: P_INSURANCE_COMPANY_TO is not null then
116:
117: SELECT vendor_name
118: INTO cp_insurance_from
119: FROM po_vendors
120: where vendor_id = P_INSURANCE_COMPANY_FROM;
121:
122: SELECT vendor_name
123: INTO cp_insurance_to

Line 124: FROM po_vendors

120: where vendor_id = P_INSURANCE_COMPANY_FROM;
121:
122: SELECT vendor_name
123: INTO cp_insurance_to
124: FROM po_vendors
125: where vendor_id = P_INSURANCE_COMPANY_TO;
126:
127: c_where_ins_company := 'and pvo.vendor_name between '''||CP_INSURANCE_FROM
128: || ''' and ''' ||CP_INSURANCE_TO || '''';