APPS.OZF_ACTBUDGETS_PVT dependencies on OZF_FUNDS_ALL_B

Line 354: FROM ozf_funds_all_b

350: WHERE activity_budget_id = p_id;
351:
352: CURSOR c_check_quota (p_type IN VARCHAR2, p_fund_id IN NUMBER) IS
353: SELECT 1
354: FROM ozf_funds_all_b
355: WHERE 'FUND' = p_type
356: AND fund_type = 'QUOTA'
357: AND fund_id = p_fund_id;
358:

Line 1379: FROM ozf_funds_all_b

1375: -- approval and rejection. the committed_amt will only
1376: -- be used in the approval.
1377: CURSOR c_fund (l_fund_id IN NUMBER) IS
1378: SELECT object_version_number, currency_code_tc, planned_amt
1379: FROM ozf_funds_all_b
1380: WHERE fund_id = l_fund_id;
1381:
1382: CURSOR c_check_quota (p_type IN VARCHAR2, p_fund_id IN NUMBER) IS
1383: SELECT 1

Line 1384: FROM ozf_funds_all_b

1380: WHERE fund_id = l_fund_id;
1381:
1382: CURSOR c_check_quota (p_type IN VARCHAR2, p_fund_id IN NUMBER) IS
1383: SELECT 1
1384: FROM ozf_funds_all_b
1385: WHERE 'FUND' = p_type
1386: AND fund_type = 'QUOTA'
1387: AND fund_id = p_fund_id;
1388:

Line 3150: l_table_name := 'OZF_FUNDS_ALL_B';

3146: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'CSCH' THEN
3147: l_table_name := 'AMS_CAMPAIGN_SCHEDULES_VL';
3148: l_pk_name := 'SCHEDULE_ID';
3149: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'FUND' THEN
3150: l_table_name := 'OZF_FUNDS_ALL_B';
3151: l_pk_name := 'FUND_ID';
3152: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'SOFT_FUND' THEN
3153: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
3154: l_pk_name := 'REQUEST_HEADER_ID';

Line 3203: l_table_name := 'OZF_FUNDS_ALL_B';

3199: l_pk_name := 'REQUEST_HEADER_ID';
3200: ELSIF p_act_budgets_rec.budget_source_type = 'FUND' THEN
3201: -- 31-Jan-2001 mpande Removed access from ozf_fund_details_V to ozf_funds_all_vl for cross organzation validation.
3202: -- l_table_name := 'AMS_FUND_DETAILS_V';
3203: l_table_name := 'OZF_FUNDS_ALL_B';
3204: l_pk_name := 'FUND_ID';
3205: ELSIF p_act_budgets_rec.budget_source_type = 'PTNR' THEN
3206: l_table_name := 'PV_PARTNERS_V';
3207: -- 09/05/2001 mpande changed as per partners new functioanlity

Line 3349: FROM ozf_funds_all_b ozf

3345: -- An offer not autogenerated from a budget should not be allow to make a negative request from a fully accrued budget.
3346:
3347: CURSOR c_fund_type (p_fund_id IN NUMBER , p_list_header_id IN NUMBER) IS
3348: SELECT 'X'
3349: FROM ozf_funds_all_b ozf
3350: WHERE ozf.fund_type = 'FULLY_ACCRUED' and ozf.fund_id = p_fund_id
3351: and ozf.plan_id = p_list_header_id;
3352:
3353: -- sangara - Bug - 4553660

Line 3366: FROM ozf_funds_all_b

3362: l_offerLedgerName VARCHAR2(30);
3363:
3364: CURSOR c_get_budget_ledger_id (p_fund_id IN NUMBER) IS
3365: SELECT NVL(ledger_id,0)
3366: FROM ozf_funds_all_b
3367: WHERE fund_id = p_fund_id;
3368:
3369: l_budgetLedger NUMBER;
3370: -- sangara - Bug - 4553660 -- changes end

Line 4131: FROM ozf_funds_all_b

4127: CURSOR c_source_fund_owner(
4128: p_source_fund_id NUMBER)
4129: IS
4130: SELECT owner
4131: FROM ozf_funds_all_b
4132: WHERE fund_id = p_source_fund_id;
4133:
4134: CURSOR c_offer_info(p_object_id IN NUMBER) IS
4135: SELECT custom_setup_id

Line 4406: FROM ozf_funds_all_b

4402: WHERE deliverable_id = p_object_id;
4403:
4404: CURSOR c_fund IS
4405: SELECT currency_code_tc
4406: FROM ozf_funds_all_b
4407: WHERE fund_id = p_object_id;
4408:
4409: CURSOR c_offer IS
4410: SELECT nvl(transaction_currency_code, fund_request_curr_code)

Line 4668: FROM ozf_funds_all_b

4664: l_act_bud_cst_msg VARCHAR2(4000);
4665:
4666: CURSOR c_fund (l_fund_id IN NUMBER) IS
4667: SELECT object_version_number, currency_code_tc, planned_amt, committed_amt, recal_committed
4668: FROM ozf_funds_all_b
4669: WHERE fund_id = l_fund_id;
4670:
4671: -- yzhao: R12 update ozf_object_fund_summary table
4672: CURSOR c_get_objfundsum_rec(p_object_type IN VARCHAR2, p_object_id IN NUMBER, p_fund_id IN NUMBER) IS

Line 5329: FROM ozf_funds_all_b

5325: l_objfundsum_rec ozf_objfundsum_pvt.objfundsum_rec_type := NULL;
5326:
5327: CURSOR c_fund (l_fund_id IN NUMBER) IS
5328: SELECT object_version_number, currency_code_tc, planned_amt
5329: FROM ozf_funds_all_b
5330: WHERE fund_id = l_fund_id;
5331:
5332: -- yzhao: R12 update ozf_object_fund_summary table
5333: CURSOR c_get_objfundsum_rec(p_object_type IN VARCHAR2, p_object_id IN NUMBER, p_fund_id IN NUMBER) IS