DBA Data[Home] [Help]

APPS.QP_UTIL_PUB dependencies on QP_LIMITS

Line 269: from qp_limits ql, qp_limit_balances qlb

265: --Transaction Record to be cancelled/amended exists. Update trxn amount.
266: --bug 13521835
267: BEGIN
268: select ql.BASIS into l_basis
269: from qp_limits ql, qp_limit_balances qlb
270: where ql.list_header_id = l_cons_trans_rec.list_header_id
271: and ql.list_line_id = l_cons_trans_rec.list_line_id
272: and ql.limit_id = qlb.limit_id
273: and qlb.limit_balance_id = l_cons_trans_rec.limit_balance_id;

Line 319: from qp_limits ql, qp_limit_balances qlb

315: WHEN NO_DATA_FOUND THEN
316: --bug13521835
317: BEGIN
318: select ql.BASIS into l_basis
319: from qp_limits ql, qp_limit_balances qlb
320: where ql.list_header_id = l_cons_trans_rec.list_header_id
321: and ql.list_line_id = l_cons_trans_rec.list_line_id
322: and ql.limit_id = qlb.limit_id
323: and qlb.limit_balance_id = l_cons_trans_rec.limit_balance_id;

Line 400: from qp_limits ql, qp_limit_balances qlb

396: qp_Preq_Grp.engine_debug('l_consumed_amount :'||l_consumed_amount);
397: --bug13521835
398: BEGIN
399: select ql.BASIS into l_basis
400: from qp_limits ql, qp_limit_balances qlb
401: where ql.list_header_id = l_cons_trans_rec.list_header_id
402: and ql.list_line_id = l_cons_trans_rec.list_line_id
403: and ql.limit_id = qlb.limit_id
404: and qlb.limit_balance_id = l_cons_trans_rec.limit_balance_id;