DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_UTIL dependencies on QP_LIST_HEADERS_VL

Line 10616: FROM qp_list_headers_vl vl,

10612: x_return_status OUT NOCOPY VARCHAR2)IS
10613:
10614: CURSOR PRICELIST_CUR( l_price_list_header_id NUMBER,l_org_id NUMBER) IS
10615: SELECT vl.LIST_HEADER_ID price_list_header_id
10616: FROM qp_list_headers_vl vl,
10617: qp_secu_list_headers_v slh
10618: WHERE slh.list_header_id = vl.LIST_HEADER_ID
10619: AND to_date(sysdate) between nvl(vl.start_date_active,to_date(sysdate)) and nvl(vl.end_date_active,to_date(sysdate))
10620: and (slh.global_flag = 'Y' OR slh.orig_org_id = l_org_id)