DBA Data[Home] [Help]

APPS.PO_PCARD_PKG dependencies on AP_CARD_SUPPLIERS

Line 254: * vendor_site_id for the supplier Pcard from ap_card_suppliers.

250: END get_site_pcard_enabled_tbl;
251:
252:
253: /* get_vendor_pcard_info returns pcard_id for the given vendor_id and
254: * vendor_site_id for the supplier Pcard from ap_card_suppliers.
255: */
256: function get_vendor_pcard_info(x_vendor_id in number,
257: x_vendor_site_id IN number) return number IS
258: x_pcard_id number;

Line 262: from ap_card_suppliers

258: x_pcard_id number;
259: begin
260: begin
261: select card_id into x_pcard_id
262: from ap_card_suppliers
263: where vendor_id = x_vendor_id
264: and vendor_site_id = x_vendor_site_id;
265: exception
266: when no_data_found then