APPS.OZF_FUND_ALLOCATIONS_PVT dependencies on OZF_FUNDS_ALL_VL

Line 102: FROM ozf_funds_all_vl

98:
99: -- cursors for budget hierarchy
100: CURSOR c_get_budget_name IS
101: SELECT short_name, owner, parent_fund_id
102: FROM ozf_funds_all_vl
103: WHERE fund_id = p_node_id;
104:
105: BEGIN
106: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1362: FROM ozf_funds_all_vl fu

1358: CURSOR c_get_fund_info(p_fund_id NUMBER) IS
1359: SELECT fu.owner, fu.start_date_active, fu.currency_code_tc, fu.fund_type,
1360: fu.org_id, fu.ledger_id, fu.department_id, fu.short_name, fu.status_code,
1361: fu.fund_number, fu.category_id, fu.custom_setup_id
1362: FROM ozf_funds_all_vl fu
1363: where fund_id = p_fund_id;
1364:
1365: CURSOR c_get_fund_owner(p_fund_id NUMBER) IS
1366: SELECT owner, short_name

Line 1367: FROM ozf_funds_all_vl

1363: where fund_id = p_fund_id;
1364:
1365: CURSOR c_get_fund_owner(p_fund_id NUMBER) IS
1366: SELECT owner, short_name
1367: FROM ozf_funds_all_vl
1368: WHERE fund_id = p_fund_id;
1369:
1370: CURSOR c_get_res_id IS
1371: SELECT resource_id

Line 2576: FROM ozf_funds_all_vl fund, ozf_act_metric_facts_all fact

2572:
2573: CURSOR c_get_child_info IS
2574: SELECT fund.fund_id, fund.object_version_number, fund.owner, fund.short_name, fund.currency_code_tc
2575: , fact.request_total_amount, fund.fund_type
2576: FROM ozf_funds_all_vl fund, ozf_act_metric_facts_all fact
2577: WHERE fund.fund_id = fact.act_metric_used_by_id
2578: AND fact.activity_metric_fact_id = p_child_fact_id
2579: AND fact.arc_act_metric_used_by = 'FUND';
2580:

Line 2940: FROM ozf_funds_all_vl

2936: WHERE activity_metric_id = p_alloc_id;
2937:
2938: CURSOR c_get_fund_info(p_fund_id NUMBER) IS
2939: SELECT object_version_number, owner, short_name, fund_type
2940: FROM ozf_funds_all_vl
2941: WHERE fund_id = p_fund_id;
2942:
2943: CURSOR c_get_root_fund_info(p_fund_id NUMBER) IS
2944: SELECT fund_type

Line 2945: FROM ozf_funds_all_vl

2941: WHERE fund_id = p_fund_id;
2942:
2943: CURSOR c_get_root_fund_info(p_fund_id NUMBER) IS
2944: SELECT fund_type
2945: FROM ozf_funds_all_vl
2946: WHERE fund_id = p_fund_id;
2947:
2948: BEGIN
2949: IF G_DEBUG THEN

Line 3442: FROM ozf_act_metric_facts_all fact, ozf_funds_all_vl fund

3438:
3439: CURSOR c_get_fact_info IS
3440: SELECT fact.status_code, fact.previous_fact_id, fact.activity_metric_id
3441: , fact.request_total_amount, fact.request_hb_amount, fund.short_name, fund.fund_type
3442: FROM ozf_act_metric_facts_all fact, ozf_funds_all_vl fund
3443: WHERE fact.activity_metric_fact_id = p_fact_id
3444: AND fact.act_metric_used_by_id = fund.fund_id;
3445:
3446: CURSOR c_get_fact_budget_owner(p_lfact_id NUMBER) IS

Line 3635: FROM ozf_act_metric_facts_all fact, ozf_funds_all_vl fund

3631: CURSOR c_get_fact_info(p_fact_id NUMBER) IS
3632: SELECT fund.owner, fund.short_name, fund.currency_code_tc
3633: , fact.status_code, fact.request_total_amount, fact.request_hb_amount
3634: , fact.activity_metric_id, fund.fund_type
3635: FROM ozf_act_metric_facts_all fact, ozf_funds_all_vl fund
3636: WHERE fact.activity_metric_fact_id = p_fact_id
3637: AND fact.arc_act_metric_used_by = 'FUND'
3638: AND fact.act_metric_used_by_id = fund.fund_id;
3639: