APPS.QP_PRICE_LIST_LINE_UTIL dependencies on QP_LIST_HEADERS_B

Line 1693: from qp_list_headers_b

1689: BEGIN
1690: BEGIN
1691: select rounding_factor
1692: into l_rounding_factor
1693: from qp_list_headers_b
1694: where list_header_id =p_price_list_header_id;
1695: EXCEPTION
1696: WHEN OTHERS THEN
1697: l_rounding_factor := -2;

Line 1721: FROM QP_LIST_HEADERS_B

1717: /* Proration Start */
1718: BEGIN
1719: SELECT ACTIVE_FLAG
1720: INTO l_active_flag
1721: FROM QP_LIST_HEADERS_B
1722: WHERE list_header_id=p_PRICE_LIST_LINE_rec.list_header_id;
1723: EXCEPTION
1724: WHEN OTHERS THEN
1725: NULL;

Line 1870: FROM QP_LIST_HEADERS_B

1866: /* Proration Start */
1867: begin
1868: SELECT ACTIVE_FLAG
1869: INTO l_active_flag
1870: FROM QP_LIST_HEADERS_B
1871: WHERE list_header_id=p_PRICE_LIST_LINE_rec.list_header_id;
1872: exception
1873: when others then
1874: null;

Line 2036: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_PRICE_LIST_LINE_rec.list_header_id)

2032: , p_PRICE_LIST_LINE_rec.break_uom_attribute -- OKS proration
2033: , p_PRICE_LIST_LINE_rec.continuous_price_break_flag -- Continuous price breaks
2034: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2035: ,to_char(p_PRICE_LIST_LINE_rec.list_line_id)
2036: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_PRICE_LIST_LINE_rec.list_header_id)
2037: );
2038: /* Added delayed request by dhgupta for bug 2018275 */
2039:
2040: qp_delayed_requests_PVT.log_request(