APPS.FARX_MAD dependencies on PO_VENDORS

Line 278: h_mesg_name := 'FA_FE_LOOKUP_IN_PO_VENDORS';

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

Line 283: from PO_VENDORS

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

Line 289: from PO_VENDORS

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