DBA Data[Home] [Help]

APPS.OZF_ACTBUDGETRULES_PVT dependencies on OZF_FUNDS_ALL_B

Line 62: FROM ozf_funds_all_b

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

Line 925: FROM ozf_funds_all_b

921: CURSOR c_approved_amount IS
922: SELECT (NVL(original_budget, 0) - NVL(holdback_amt, 0)
923: + NVL(transfered_in_amt, 0) - NVL(transfered_out_amt, 0))
924: - NVL (committed_amt, 0)
925: FROM ozf_funds_all_b
926: WHERE fund_id = p_source_id;
927: /*
928: CURSOR c_approved_amount IS
929: SELECT NVL (available_budget, 0)