APPS.AHL_DI_SUBSCRIPTION_PVT dependencies on PO_HEADERS_V

Line 150: FROM PO_HEADERS_V

146: -- Get Puchase Order Number from PO_PURCHASE_ORDER_V
147: CURSOR for_ponumber_id(c_ponumber IN VARCHAR2)
148: IS
149: SELECT distinct segment1
150: FROM PO_HEADERS_V
151: WHERE nvl(approved_flag, 'N')='Y' and upper(segment1) = upper(c_ponumber);
152: --
153:
154: l_requested_by_name VARCHAR2(301) := NULL;