APPS.DPP_PRICING_PVT dependencies on QP_SECU_LIST_HEADERS_V

Line 75: qp_secu_list_headers_v qlh,

71:
72: SELECT
73: qlh.name Pricelist_Name
74: FROM
75: qp_secu_list_headers_v qlh,
76: qp_list_lines_v qll
77: WHERE
78: qlh.active_flag = 'Y' AND
79: g_trunc_sysdate BETWEEN nvl(qlh.start_date_active, g_trunc_sysdate) AND

Line 351: FROM qp_secu_list_headers_v qlh,

347:
348: CURSOR get_pricelist_csr(p_inventory_item_id IN NUMBER, p_vendor_id IN NUMBER,p_vendor_site_id IN NUMBER, p_org_id IN NUMBER)
349: IS
350: SELECT qlh.name Pricelist_Name
351: FROM qp_secu_list_headers_v qlh,
352: qp_qualifiers_v qqv,
353: qp_list_lines_v qll
354: WHERE qlh.active_flag='Y'
355: and g_trunc_sysdate between nvl(qlh.start_date_active,g_trunc_sysdate)

Line 370: FROM qp_secu_list_headers_v qlh,

366: and nvl(qll.end_date_active,g_trunc_sysdate)
367: AND (qlh.orig_org_id = p_org_id OR NVL(qlh.global_flag,'N') = 'Y')
368: UNION
369: SELECT qlh.name Pricelist_Name
370: FROM qp_secu_list_headers_v qlh,
371: qp_qualifiers_v qqv,
372: qp_list_lines_v qll
373: WHERE qlh.active_flag='Y'
374: and g_trunc_sysdate between nvl(qlh.start_date_active,g_trunc_sysdate)