APPS.OZF_FUND_REQUEST_APR_PVT dependencies on OZF_FUNDS_ALL_B

Line 910: FROM ozf_funds_all_b

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

Line 918: FROM ozf_funds_all_b

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

Line 2220: FROM ozf_funds_all_b

2216: CURSOR c_src_category(
2217: p_src_id IN NUMBER)
2218: IS
2219: SELECT to_char(category_id)
2220: FROM ozf_funds_all_b
2221: WHERE fund_id = p_src_id;
2222: /* End of Addition for category-approval*/
2223:
2224: CURSOR c_fund_rec(

Line 2612: FROM ozf_funds_all_b

2608: l_org_id number := NULL;
2609:
2610: CURSOR get_fund_org_csr(p_id in number) IS
2611: SELECT org_id
2612: FROM ozf_funds_all_b
2613: WHERE fund_id = p_id;
2614:
2615: BEGIN
2616:

Line 2706: ,ozf_funds_all_b fund

2702: ,act_budget_used_by_id approval_for_id
2703: ,request_currency
2704: ,fund.currency_code_tc
2705: FROM ozf_act_budgets act
2706: ,ozf_funds_all_b fund
2707: WHERE activity_budget_id = p_act_budget_id
2708: AND act.budget_source_id = fund.fund_id;
2709:
2710: BEGIN

Line 3036: FROM ozf_funds_all_b

3032: SELECT fund_id
3033: ,(NVL(original_budget, 0) - NVL(holdback_amt, 0) + NVL(transfered_in_amt,0) - NVL(transfered_out_amt, 0)- NVL(committed_amt,0)) available_budget
3034: ,holdback_amt
3035: ,object_version_number
3036: FROM ozf_funds_all_b
3037: WHERE fund_id = cv_fund_id;
3038:
3039: l_holdback_amt NUMBER;
3040: l_available_amt NUMBER;