APPS.QP_PRICING_ATTR_UTIL dependencies on QP_LIST_HEADERS_B

Line 1439: FROM QP_LIST_HEADERS_B lh, QP_LIST_LINES ll

1435: --End Bug 5465263
1436:
1437: SELECT lh.ACTIVE_FLAG
1438: INTO l_active_flag
1439: FROM QP_LIST_HEADERS_B lh, QP_LIST_LINES ll
1440: WHERE lh.LIST_HEADER_ID = ll.LIST_HEADER_ID and ll.LIST_LINE_ID = p_PRICING_ATTR_rec.list_line_id and rownum = 1;
1441:
1442: oe_debug_pub.add('BEGIN Update_Row in QPXUPRAB');
1443:

Line 1631: FROM QP_LIST_HEADERS_B

1627:
1628: IF p_PRICING_ATTR_rec.list_header_id IS NOT NULL THEN
1629: SELECT ACTIVE_FLAG
1630: INTO l_active_flag
1631: FROM QP_LIST_HEADERS_B
1632: WHERE LIST_HEADER_ID = p_PRICING_ATTR_rec.list_header_id;
1633:
1634: ELSE
1635:

Line 1638: FROM QP_LIST_HEADERS_B a,QP_LIST_LINES b

1634: ELSE
1635:
1636: SELECT ACTIVE_FLAG
1637: INTO l_active_flag
1638: FROM QP_LIST_HEADERS_B a,QP_LIST_LINES b
1639: WHERE b.list_line_id=p_PRICING_ATTR_rec.list_line_id
1640: AND b.LIST_HEADER_ID = a.list_header_id;
1641: END IF;
1642: oe_debug_pub.add('BEGIN Insert_Row in QPXUPRAB');