APPS.OZF_QUOTA_ALLOCATIONS_PVT dependencies on OZF_FUNDS_ALL_VL

Line 85: FROM OZF_FUNDS_ALL_VL FF

81: AND PARENT_PARTY_ID = -9999;
82:
83: CURSOR c_unallocated_amt_non_leaf(p_quota_id NUMBER) IS
84: SELECT ((NVL(FF.ORIGINAL_BUDGET,0) + NVL(FF.TRANSFERED_IN_AMT,0)) - NVL(FF.TRANSFERED_OUT_AMT,0)) UNALLOCATED_AMT
85: FROM OZF_FUNDS_ALL_VL FF
86: WHERE FF.FUND_ID = p_quota_id;
87:
88: l_return VARCHAR2(1) := 'N';
89: l_quota_start_date DATE;