DBA Data[Home] [Help]

APPS.AP_WEB_DB_PO_INT_PKG dependencies on PO_VENDOR_SITES

Line 58: /*IF (PO_VENDOR_SITES_SV.val_vendor_site_id('PO',p_vendor_site_id)) THEN

54: BEGIN
55:
56: /* Check if the given Supplier Site is active. */
57: /* We are ignoring the effective date for now. */
58: /*IF (PO_VENDOR_SITES_SV.val_vendor_site_id('PO',p_vendor_site_id)) THEN
59: RETURN 'Y';
60: ELSE
61: RETURN 'N';
62: END IF;*/

Line 66: FROM po_vendor_sites

62: END IF;*/
63:
64: SELECT vendor_site_id
65: INTO l_vendor_site_id
66: FROM po_vendor_sites
67: WHERE vendor_site_id = p_vendor_site_id
68: AND SYSDATE < NVL(inactive_date, SYSDATE + 1)
69: AND NVL(pay_site_flag,'N')='Y';
70: