APPS.QP_LIMIT_BALANCE_CHECK_PVT dependencies on QP_LIMITS

Line 63: select limit_number into l_limit_number from qp_limits

59: END;
60: END IF;
61:
62: BEGIN
63: select limit_number into l_limit_number from qp_limits
64: where limit_id = p_Limit_Id;
65: EXCEPTION
66: when no_data_found then
67: IF l_debug = FND_API.G_TRUE THEN

Line 1891: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_HEADER_ID,1

1887: IS
1888: /*
1889: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,PRICING_STATUS_CODE,1
1890: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,HEADER_LIMIT_EXISTS,2
1891: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_HEADER_ID,1
1892: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_LINE_ID,2
1893: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMIT_ATTRIBUTES_N1,LIMIT_ID,1
1894: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
1895: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2

Line 1892: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_LINE_ID,2

1888: /*
1889: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,PRICING_STATUS_CODE,1
1890: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,HEADER_LIMIT_EXISTS,2
1891: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_HEADER_ID,1
1892: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_LINE_ID,2
1893: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMIT_ATTRIBUTES_N1,LIMIT_ID,1
1894: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
1895: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
1896: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3

Line 1938: FROM qp_npreq_ldets_tmp r, qp_limits l,

1934: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
1935: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
1936: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
1937: q.priced_quantity quantity_wanted
1938: FROM qp_npreq_ldets_tmp r, qp_limits l,
1939: qp_limit_attributes a, qp_npreq_line_attrs_tmp rl, qp_npreq_lines_tmp q
1940: WHERE r.created_from_list_header_id = l.list_header_id
1941: AND r.created_from_list_line_id = l.list_line_id
1942: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

Line 2007: FROM qp_npreq_ldets_tmp r, qp_limits l, qp_npreq_lines_tmp q

2003: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
2004: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
2005: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
2006: q.priced_quantity quantity_wanted
2007: FROM qp_npreq_ldets_tmp r, qp_limits l, qp_npreq_lines_tmp q
2008: WHERE r.created_from_list_header_id = l.list_header_id
2009: AND r.created_from_list_line_id = l.list_line_id
2010: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2011: AND r.applied_flag = 'Y' -- [5385851/5322832]

Line 2052: FROM qp_npreq_ldets_tmp r, qp_limits l,

2048: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
2049: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
2050: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
2051: q.priced_quantity quantity_wanted
2052: FROM qp_npreq_ldets_tmp r, qp_limits l,
2053: qp_limit_attributes a, qp_npreq_line_attrs_tmp rl, qp_npreq_lines_tmp q
2054: WHERE r.created_from_list_header_id = l.list_header_id
2055: AND l.list_line_id = -1
2056: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

Line 2121: FROM qp_npreq_ldets_tmp r, qp_limits l, qp_npreq_lines_tmp q

2117: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
2118: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
2119: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
2120: q.priced_quantity quantity_wanted
2121: FROM qp_npreq_ldets_tmp r, qp_limits l, qp_npreq_lines_tmp q
2122: WHERE r.created_from_list_header_id = l.list_header_id
2123: AND l.list_line_id = -1
2124: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2125: AND r.applied_flag = 'Y' -- [5385851/5322832]