APPS.OZF_FUND_REQUEST_APR_PVT dependencies on OZF_FUNDS_ALL_B

Line 913: FROM ozf_funds_all_b

909: CURSOR c_fund_detail(
910: cv_fund_id NUMBER)
911: IS
912: SELECT object_version_number
913: FROM ozf_funds_all_b
914: WHERE fund_id = cv_fund_id;
915:
916: -- Cursor to find the owner of the parent fund
917: CURSOR c_parent_fund_owner(

Line 921: FROM ozf_funds_all_b

917: CURSOR c_parent_fund_owner(
918: p_parent_fund_id NUMBER)
919: IS
920: SELECT owner
921: FROM ozf_funds_all_b
922: WHERE fund_id = p_parent_fund_id;
923:
924: -- cursors to get the transfer from and transfer to currency
925: CURSOR c_fm_fund_currency(

Line 2241: FROM ozf_funds_all_b

2237: CURSOR c_src_category(
2238: p_src_id IN NUMBER)
2239: IS
2240: SELECT to_char(category_id)
2241: FROM ozf_funds_all_b
2242: WHERE fund_id = p_src_id;
2243: /* End of Addition for category-approval*/
2244:
2245: CURSOR c_fund_rec(

Line 2640: FROM ozf_funds_all_b

2636: l_org_id number := NULL;
2637:
2638: CURSOR get_fund_org_csr(p_id in number) IS
2639: SELECT org_id
2640: FROM ozf_funds_all_b
2641: WHERE fund_id = p_id;
2642:
2643: BEGIN
2644:

Line 2734: ,ozf_funds_all_b fund

2730: ,act_budget_used_by_id approval_for_id
2731: ,request_currency
2732: ,fund.currency_code_tc
2733: FROM ozf_act_budgets act
2734: ,ozf_funds_all_b fund
2735: WHERE activity_budget_id = p_act_budget_id
2736: AND act.budget_source_id = fund.fund_id;
2737:
2738: BEGIN

Line 3064: FROM ozf_funds_all_b

3060: SELECT fund_id
3061: ,(NVL(original_budget, 0) - NVL(holdback_amt, 0) + NVL(transfered_in_amt,0) - NVL(transfered_out_amt, 0)- NVL(committed_amt,0)) available_budget
3062: ,holdback_amt
3063: ,object_version_number
3064: FROM ozf_funds_all_b
3065: WHERE fund_id = cv_fund_id;
3066:
3067: l_holdback_amt NUMBER;
3068: l_available_amt NUMBER;