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 1212: UPDATE ozf_funds_all_b

1208: END IF;
1209: END IF;
1210:
1211: IF p_mode = 'CREATE' THEN
1212: UPDATE ozf_funds_all_b
1213: SET plan_id = l_qp_list_header_id,
1214: plan_type = 'OFFR'
1215: WHERE fund_id = p_fund_rec.fund_id;
1216: ELSIF p_mode = 'UPDATE' THEN

Line 1455: FROM ozf_funds_all_b

1451: CURSOR c_get_fund_amount IS
1452: SELECT (NVL(original_budget, 0) + NVL(transfered_in_amt,0) - NVL(transfered_out_amt, 0))
1453: , NVL(recal_committed, 0),
1454: NVL(utilized_amt, 0), NVL(earned_amt, 0), NVL(paid_amt, 0), fund_type -- yzhao: 11.5.10 added utilized_amt
1455: FROM ozf_funds_all_b
1456: WHERE fund_id = p_fund_id;
1457:
1458: l_recal_flag VARCHAR2(1);
1459: l_total_budget NUMBER;

Line 1596: FROM ozf_funds_all_b

1592: user_status_id,
1593: owner,
1594: fund_type,
1595: plan_id
1596: FROM ozf_funds_all_b
1597: WHERE fund_id = p_fund_rec.fund_id;
1598:
1599: -- Cursor to find the owner of the parent fund
1600: CURSOR c_parent_fund_owner(

Line 1603: FROM ozf_funds_all_b

1599: -- Cursor to find the owner of the parent fund
1600: CURSOR c_parent_fund_owner(
1601: p_parent_fund_id NUMBER) IS
1602: SELECT owner
1603: FROM ozf_funds_all_b
1604: WHERE fund_id = p_parent_fund_id;
1605:
1606: BEGIN
1607: SAVEPOINT update_fund_status;

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

1702: /* yzhao: 01/29/2003 fix bug 2775762 MKTF1R9:1159.0127:FUNC: ACCRUAL BUDGET CANNOT GO ACTIVE
1703: for accrual budget, check if discount rule already defined
1704: SELECT 1
1705: FROM qp_list_lines
1706: WHERE list_header_id = (SELECT plan_id FROM ozf_funds_all_b WHERE fund_id = p_fund_rec.fund_id);
1707: */
1708: IF (l_fund_type = 'FULLY_ACCRUED') THEN
1709: l_list_line := ozf_offer_pvt.discount_lines_exist(p_list_header_id => l_plan_id);
1710: IF l_list_line <> 0 THEN