APPS.OZF_FUNDRULES_PVT dependencies on OZF_FUNDS_ALL_B

Line 841: FROM ozf_funds_all_b

837: CURSOR c_old_fund(
838: cv_fund_id IN NUMBER)
839: IS
840: SELECT status_code
841: FROM ozf_funds_all_b
842: WHERE fund_id = cv_fund_id;
843:
844: BEGIN
845: SAVEPOINT process_offers;

Line 1163: UPDATE ozf_funds_all_b

1159: END IF;
1160: END IF;
1161:
1162: IF p_mode = 'CREATE' THEN
1163: UPDATE ozf_funds_all_b
1164: SET plan_id = l_qp_list_header_id,
1165: plan_type = 'OFFR'
1166: WHERE fund_id = p_fund_rec.fund_id;
1167: ELSIF p_mode = 'UPDATE' THEN

Line 1406: FROM ozf_funds_all_b

1402: CURSOR c_get_fund_amount IS
1403: SELECT (NVL(original_budget, 0) + NVL(transfered_in_amt,0) - NVL(transfered_out_amt, 0))
1404: , NVL(recal_committed, 0),
1405: NVL(utilized_amt, 0), NVL(earned_amt, 0), NVL(paid_amt, 0), fund_type -- yzhao: 11.5.10 added utilized_amt
1406: FROM ozf_funds_all_b
1407: WHERE fund_id = p_fund_id;
1408:
1409: l_recal_flag VARCHAR2(1);
1410: l_total_budget NUMBER;

Line 1547: FROM ozf_funds_all_b

1543: user_status_id,
1544: owner,
1545: fund_type,
1546: plan_id
1547: FROM ozf_funds_all_b
1548: WHERE fund_id = p_fund_rec.fund_id;
1549:
1550: -- Cursor to find the owner of the parent fund
1551: CURSOR c_parent_fund_owner(

Line 1554: FROM ozf_funds_all_b

1550: -- Cursor to find the owner of the parent fund
1551: CURSOR c_parent_fund_owner(
1552: p_parent_fund_id NUMBER) IS
1553: SELECT owner
1554: FROM ozf_funds_all_b
1555: WHERE fund_id = p_parent_fund_id;
1556:
1557: BEGIN
1558: SAVEPOINT update_fund_status;

Line 1657: WHERE list_header_id = (SELECT plan_id FROM ozf_funds_all_b WHERE fund_id = p_fund_rec.fund_id);

1653: /* yzhao: 01/29/2003 fix bug 2775762 MKTF1R9:1159.0127:FUNC: ACCRUAL BUDGET CANNOT GO ACTIVE
1654: for accrual budget, check if discount rule already defined
1655: SELECT 1
1656: FROM qp_list_lines
1657: WHERE list_header_id = (SELECT plan_id FROM ozf_funds_all_b WHERE fund_id = p_fund_rec.fund_id);
1658: */
1659: IF (l_fund_type = 'FULLY_ACCRUED') THEN
1660: l_list_line := ozf_offer_pvt.discount_lines_exist(p_list_header_id => l_plan_id);
1661: IF l_list_line <> 0 THEN