APPS.QP_PRICING_ATTR_UTIL dependencies on QP_LIST_HEADERS_B

Line 1455: FROM QP_LIST_HEADERS_B lh, QP_LIST_LINES ll

1451: --End Bug 5465263
1452:
1453: SELECT lh.ACTIVE_FLAG
1454: INTO l_active_flag
1455: FROM QP_LIST_HEADERS_B lh, QP_LIST_LINES ll
1456: WHERE lh.LIST_HEADER_ID = ll.LIST_HEADER_ID and ll.LIST_LINE_ID = p_PRICING_ATTR_rec.list_line_id and rownum = 1;
1457:
1458: oe_debug_pub.add('BEGIN Update_Row in QPXUPRAB');
1459:

Line 1647: FROM QP_LIST_HEADERS_B

1643:
1644: IF p_PRICING_ATTR_rec.list_header_id IS NOT NULL THEN
1645: SELECT ACTIVE_FLAG
1646: INTO l_active_flag
1647: FROM QP_LIST_HEADERS_B
1648: WHERE LIST_HEADER_ID = p_PRICING_ATTR_rec.list_header_id;
1649:
1650: ELSE
1651:

Line 1654: FROM QP_LIST_HEADERS_B a,QP_LIST_LINES b

1650: ELSE
1651:
1652: SELECT ACTIVE_FLAG
1653: INTO l_active_flag
1654: FROM QP_LIST_HEADERS_B a,QP_LIST_LINES b
1655: WHERE b.list_line_id=p_PRICING_ATTR_rec.list_line_id
1656: AND b.LIST_HEADER_ID = a.list_header_id;
1657: END IF;
1658: oe_debug_pub.add('BEGIN Insert_Row in QPXUPRAB');