DBA Data[Home] [Help]

APPS.PN_LEASE_UTILS dependencies on PO_VENDORS

Line 2121: FROM po_vendors

2117: CURSOR c_vendor
2118: IS
2119: -- select * from pn_payment_terms_all where lease_id = 1057
2120: SELECT vendor_id
2121: FROM po_vendors
2122: WHERE enabled_flag = 'Y'
2123: AND TRUNC (SYSDATE) <= NVL (end_date_active, SYSDATE)
2124: AND vendor_name = p_vendor_name;
2125:

Line 2129: FROM po_vendors

2125:
2126: CURSOR c_vendor_id
2127: IS
2128: SELECT vendor_id
2129: FROM po_vendors
2130: WHERE enabled_flag = 'Y'
2131: AND TRUNC (SYSDATE) <= NVL (end_date_active, SYSDATE)
2132: AND vendor_id = x_vendor_id;
2133: BEGIN