APPS.AS_OPP_HEADER_PVT dependencies on QP_PRICE_LISTS_V

Line 3855: FROM qp_price_lists_v

3851: IS
3852: CURSOR C_Price_List_Exists (c_Price_List_Id NUMBER,
3853: c_Currency_Code VARCHAR2) IS
3854: SELECT 'X'
3855: FROM qp_price_lists_v
3856: WHERE price_list_id = c_Price_List_Id
3857: and currency_code = c_Currency_Code
3858: and nvl(start_date_active, sysdate) <= sysdate
3859: and nvl(end_date_active, sysdate) >= sysdate;

Line 3877: -- PRICE_LIST_ID should exist in qp_price_lists_v

3873:
3874: IF (p_PRICE_LIST_ID is NOT NULL) and
3875: (p_PRICE_LIST_ID <> FND_API.G_MISS_NUM)
3876: THEN
3877: -- PRICE_LIST_ID should exist in qp_price_lists_v
3878: OPEN C_Price_List_Exists (p_PRICE_LIST_ID, p_CURRENCY_CODE);
3879: FETCH C_Price_List_Exists into l_val;
3880:
3881: IF C_Price_List_Exists%NOTFOUND THEN