APPS.QP_PRICE_LIST_LINE_UTIL dependencies on QP_LIST_HEADERS_B

Line 1688: from qp_list_headers_b

1684: BEGIN
1685: BEGIN
1686: select rounding_factor
1687: into l_rounding_factor
1688: from qp_list_headers_b
1689: where list_header_id =p_price_list_header_id;
1690: EXCEPTION
1691: WHEN OTHERS THEN
1692: l_rounding_factor := -2;

Line 1716: FROM QP_LIST_HEADERS_B

1712: /* Proration Start */
1713: BEGIN
1714: SELECT ACTIVE_FLAG
1715: INTO l_active_flag
1716: FROM QP_LIST_HEADERS_B
1717: WHERE list_header_id=p_PRICE_LIST_LINE_rec.list_header_id;
1718: EXCEPTION
1719: WHEN OTHERS THEN
1720: NULL;

Line 1865: FROM QP_LIST_HEADERS_B

1861: /* Proration Start */
1862: begin
1863: SELECT ACTIVE_FLAG
1864: INTO l_active_flag
1865: FROM QP_LIST_HEADERS_B
1866: WHERE list_header_id=p_PRICE_LIST_LINE_rec.list_header_id;
1867: exception
1868: when others then
1869: null;

Line 2031: ,(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)

2027: , p_PRICE_LIST_LINE_rec.break_uom_attribute -- OKS proration
2028: , p_PRICE_LIST_LINE_rec.continuous_price_break_flag -- Continuous price breaks
2029: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2030: ,to_char(p_PRICE_LIST_LINE_rec.list_line_id)
2031: ,(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: );
2033: /* Added delayed request by dhgupta for bug 2018275 */
2034:
2035: qp_delayed_requests_PVT.log_request(