APPS.AS_OPP_HEADER_PVT dependencies on QP_PRICE_LISTS_V

Line 3854: FROM qp_price_lists_v

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

Line 3876: -- PRICE_LIST_ID should exist in qp_price_lists_v

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