DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on PO_VENDORS

Line 3176: FROM po_vendors v

3172: ;
3173:
3174: CURSOR c_supplier IS
3175: SELECT 1
3176: FROM po_vendors v
3177: WHERE v.vendor_id = p_sample.supplier_id
3178: AND v.enabled_flag = 'Y'
3179: AND sysdate between nvl(v.start_date_active, sysdate-1)
3180: and nvl(v.end_date_active, sysdate+1)

Line 5085: FROM PO_VENDORS

5081: IS
5082: -- M. Grosser 28-Feb-2006 Bug 5016617 - Added retrieval of supplier name
5083: CURSOR Cur_get_supplier IS
5084: SELECT SEGMENT1, VENDOR_NAME
5085: FROM PO_VENDORS
5086: WHERE vendor_id = p_supplier_id;
5087:
5088: CURSOR Cur_get_po IS
5089: SELECT SEGMENT1