APPS.QP_LIMIT_CONC_REQ dependencies on QP_LIMIT_BALANCES

Line 61: from qp_limit_balances

57: IS
58: --
59: cursor lmt_balances (l_limit_id in number) is
60: select *
61: from qp_limit_balances
62: where limit_id = l_limit_id and
63: limit_balance_id = nvl(p_limit_balance_id,limit_balance_id)
64: for update;
65: --

Line 74: l_balance_row qp_limit_balances%rowtype;

70: limit_id = nvl(p_limit_id,limit_id) and
71: list_line_id = nvl(p_list_line_id,list_line_id);
72: --
73: l_limits_row qp_limits%rowtype;
74: l_balance_row qp_limit_balances%rowtype;
75: l_trans_total number;
76: --
77: BEGIN
78: --dbms_output.enable(1000000);

Line 93: update qp_limit_balances

89: exit when lmt_balances%notfound;
90: --
91: l_trans_total := p_trans_total(l_balance_row.limit_balance_id);
92: --
93: update qp_limit_balances
94: set available_amount = nvl(l_limits_row.amount,0) - l_trans_total,
95: consumed_amount = l_trans_total
96: where current of lmt_balances;
97: --