APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on QP_LIST_HEADERS_V

Line 80: SELECT name from qp_list_headers_vl

76: WHERE visit_id = p_visit_id
77: and nvl(status_code, 'x') <>'DELETED';
78:
79: CURSOR price_list_name_csr(p_price_list_id IN NUMBER) IS
80: SELECT name from qp_list_headers_vl
81: WHERE list_header_id = p_price_list_id;
82:
83: -- Begin Procedure code
84: BEGIN

Line 440: FROM qp_list_headers_v

436: and nvl(status_code, 'x') <>'DELETED';
437:
438: CURSOR price_list_dates_csr(p_price_list_id IN NUMBER)IS
439: SELECT start_date_active, end_date_active
440: FROM qp_list_headers_v
441: WHERE list_header_id = p_price_list_id;
442:
443: l_price_list_active_start_date DATE;
444: l_price_list_active_end_date DATE;