DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on PO_VENDORS

Line 3771: FROM po_vendors v

3767: ;
3768:
3769: CURSOR c_supplier IS
3770: SELECT 1
3771: FROM po_vendors v
3772: WHERE v.vendor_id = p_sample.supplier_id
3773: AND v.enabled_flag = 'Y'
3774: AND sysdate between nvl(v.start_date_active, sysdate-1)
3775: and nvl(v.end_date_active, sysdate+1)

Line 5753: FROM PO_VENDORS

5749: IS
5750: -- M. Grosser 28-Feb-2006 Bug 5016617 - Added retrieval of supplier name
5751: CURSOR Cur_get_supplier IS
5752: SELECT SEGMENT1, VENDOR_NAME
5753: FROM PO_VENDORS
5754: WHERE vendor_id = p_supplier_id;
5755:
5756: CURSOR Cur_get_po IS
5757: SELECT SEGMENT1