DBA Data[Home] [Help]

APPS.OZF_ACTBUDGETRULES_PVT dependencies on OZF_FUNDS_ALL_B

Line 59: FROM ozf_funds_all_b

55: WHERE category_id = p_category_id;
56:
57: CURSOR c_get_category_id (p_budget_source_id IN NUMBER) IS
58: SELECT category_id
59: FROM ozf_funds_all_b
60: WHERE fund_id = p_budget_source_id;
61:
62: l_activity_id NUMBER;
63: l_category_id NUMBER;

Line 919: FROM ozf_funds_all_b

915: CURSOR c_approved_amount IS
916: SELECT (NVL(original_budget, 0) - NVL(holdback_amt, 0)
917: + NVL(transfered_in_amt, 0) - NVL(transfered_out_amt, 0))
918: - NVL (committed_amt, 0)
919: FROM ozf_funds_all_b
920: WHERE fund_id = p_source_id;
921: /*
922: CURSOR c_approved_amount IS
923: SELECT NVL (available_budget, 0)