DBA Data[Home] [Help]

APPS.AHL_VWP_TASK_CST_PR_PVT dependencies on QP_LIST_HEADERS_VL

Line 877: FROM qp_list_headers_vl qlhv, qp_qualifiers qpq

873:
874: CURSOR price_list_id_csr(p_price_list_name IN VARCHAR2,p_customer_id IN NUMBER)
875: IS
876: SELECT qlhv.list_header_id
877: FROM qp_list_headers_vl qlhv, qp_qualifiers qpq
878: WHERE qlhv.list_type_code = 'PRL'
879: AND upper(qlhv.name) like upper(p_price_list_name)
880: AND qpq.QUALIFIER_ATTR_VALUE = p_customer_id
881: AND qpq.list_header_id=qlhv.list_header_id