APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on QP_LIST_HEADERS_V

Line 84: SELECT name from qp_list_headers_vl

80: and task_type_code <> 'STAGE'; -- added the condition by TCHIMIRA on 12-JUL-2011 -VWP: ER:12673125
81:
82:
83: CURSOR price_list_name_csr(p_price_list_id IN NUMBER) IS
84: SELECT name from qp_list_headers_vl
85: WHERE list_header_id = p_price_list_id;
86:
87: --salogan::Added Cursor to fetch conc request details CP ER 9299910::01-JUN-2009::BEGIN
88: CURSOR c_conc_req_details(x_cp_req_id IN NUMBER) IS

Line 487: FROM qp_list_headers_v

483: and task_type_code <> 'STAGE'; -- added the condition by TCHIMIRA on 12-JUL-2011 -VWP: ER:12673125
484:
485: CURSOR price_list_dates_csr(p_price_list_id IN NUMBER)IS
486: SELECT start_date_active, end_date_active
487: FROM qp_list_headers_v
488: WHERE list_header_id = p_price_list_id;
489:
490: l_price_list_active_start_date DATE;
491: l_price_list_active_end_date DATE;