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 1830: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_HEADER_ID,1

1826: IS
1827: /*
1828: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,PRICING_STATUS_CODE,1
1829: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,HEADER_LIMIT_EXISTS,2
1830: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_HEADER_ID,1
1831: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_LINE_ID,2
1832: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMIT_ATTRIBUTES_N1,LIMIT_ID,1
1833: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
1834: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2

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

1827: /*
1828: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,PRICING_STATUS_CODE,1
1829: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,HEADER_LIMIT_EXISTS,2
1830: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_HEADER_ID,1
1831: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_LINE_ID,2
1832: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMIT_ATTRIBUTES_N1,LIMIT_ID,1
1833: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
1834: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
1835: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3

Line 1877: FROM qp_npreq_ldets_tmp r, qp_limits l,

1873: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
1874: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
1875: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
1876: q.priced_quantity quantity_wanted
1877: FROM qp_npreq_ldets_tmp r, qp_limits l,
1878: qp_limit_attributes a, qp_npreq_line_attrs_tmp rl, qp_npreq_lines_tmp q
1879: WHERE r.created_from_list_header_id = l.list_header_id
1880: AND r.created_from_list_line_id = l.list_line_id
1881: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

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

1942: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
1943: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
1944: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
1945: q.priced_quantity quantity_wanted
1946: FROM qp_npreq_ldets_tmp r, qp_limits l, qp_npreq_lines_tmp q
1947: WHERE r.created_from_list_header_id = l.list_header_id
1948: AND r.created_from_list_line_id = l.list_line_id
1949: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
1950: AND r.applied_flag = 'Y' -- [5385851/5322832]

Line 1991: FROM qp_npreq_ldets_tmp r, qp_limits l,

1987: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
1988: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
1989: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
1990: q.priced_quantity quantity_wanted
1991: FROM qp_npreq_ldets_tmp r, qp_limits l,
1992: qp_limit_attributes a, qp_npreq_line_attrs_tmp rl, qp_npreq_lines_tmp q
1993: WHERE r.created_from_list_header_id = l.list_header_id
1994: AND l.list_line_id = -1
1995: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

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

2056: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
2057: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
2058: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
2059: q.priced_quantity quantity_wanted
2060: FROM qp_npreq_ldets_tmp r, qp_limits l, qp_npreq_lines_tmp q
2061: WHERE r.created_from_list_header_id = l.list_header_id
2062: AND l.list_line_id = -1
2063: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2064: AND r.applied_flag = 'Y' -- [5385851/5322832]