APPS.FARX_MAD dependencies on PO_VENDORS

Line 277: h_mesg_name := 'FA_FE_LOOKUP_IN_PO_VENDORS';

273:
274:
275: if (c_maddrec.po_vendor_id is not null) then
276:
277: h_mesg_name := 'FA_FE_LOOKUP_IN_PO_VENDORS';
278: /* -- To avoid issues such as 3189133. Need to check if
279: -- po_vendor_id is not an invalid value; i.e., in the case of legacy data. */
280: SELECT count(1)
281: INTO h_valid_vendor_id

Line 282: from PO_VENDORS

278: /* -- To avoid issues such as 3189133. Need to check if
279: -- po_vendor_id is not an invalid value; i.e., in the case of legacy data. */
280: SELECT count(1)
281: INTO h_valid_vendor_id
282: from PO_VENDORS
283: where vendor_id = c_maddrec.po_vendor_id;
284:
285: if h_valid_vendor_id > 0 then
286: SELECT vendor_name

Line 288: from PO_VENDORS

284:
285: if h_valid_vendor_id > 0 then
286: SELECT vendor_name
287: into h_vendor_name
288: from PO_VENDORS
289: where vendor_id = c_maddrec.po_vendor_id;
290: end if;
291:
292: end if;