APPS.QP_VALIDATE_LIMITS dependencies on QP_LIMIT_BALANCES

Line 1299: SELECT count(*) into l_dummy from QP_LIMIT_BALANCES

1295: BEGIN
1296:
1297: -- Validate entity delete.
1298:
1299: SELECT count(*) into l_dummy from QP_LIMIT_BALANCES
1300: WHERE limit_id = p_LIMITS_rec.limit_id
1301: AND nvl(consumed_amount,0) > 0;
1302:
1303: IF l_dummy = 0

Line 1359: SELECT count(*) into l_dummy from QP_LIMIT_BALANCES

1355: -- Validate entity update.
1356:
1357: l_limits_rec := QP_Limits_Util.Query_Row(p_LIMITS_rec.limit_id);
1358:
1359: SELECT count(*) into l_dummy from QP_LIMIT_BALANCES
1360: WHERE limit_id = p_LIMITS_rec.limit_id
1361: AND nvl(consumed_amount,0) > 0;
1362:
1363: SELECT MAX(consumed_amount) INTO l_consumed_amount FROM QP_LIMIT_BALANCES

Line 1363: SELECT MAX(consumed_amount) INTO l_consumed_amount FROM QP_LIMIT_BALANCES

1359: SELECT count(*) into l_dummy from QP_LIMIT_BALANCES
1360: WHERE limit_id = p_LIMITS_rec.limit_id
1361: AND nvl(consumed_amount,0) > 0;
1362:
1363: SELECT MAX(consumed_amount) INTO l_consumed_amount FROM QP_LIMIT_BALANCES
1364: WHERE limit_id = p_LIMITS_rec.limit_id;
1365:
1366: IF l_dummy = 0
1367: THEN