DBA Data[Home] [Help]

APPS.IBE_SHOP_LIST_PVT dependencies on QP_LIST_HEADERS_VL

Line 2726: FROM qp_list_headers_vl

2722: l_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
2723:
2724: Cursor c_get_promo_details(p_promocode VARCHAR2, p_currency_code VARCHAR2) is
2725: SELECT list_header_id
2726: FROM qp_list_headers_vl
2727: WHERE NVL(start_date_active, SYSDATE) <= SYSDATE
2728: AND NVL(end_date_active+1, SYSDATE) >= SYSDATE
2729: AND list_type_code = 'PRO'
2730: AND active_flag = 'Y'