APPS.OZF_ACTBUDGETRULES_PVT dependencies on OZF_OBJECT_FUND_SUMMARY

Line 135: FROM ozf_object_fund_summary

131: -- for TRANSFER type, check for individual budget.
132: CURSOR c_transfer_allowed IS
133: /*
134: SELECT (NVL(plan_curr_committed_amt,0)-NVL(plan_curr_utilized_amt,0)) total_amount
135: FROM ozf_object_fund_summary
136: WHERE object_id =p_object_id
137: AND object_type = p_object_type
138: AND fund_id = p_budget_source_id;
139: */

Line 171: FROM ozf_object_fund_summary

167:
168: -- for UTILIZED type, check for total committed amount.
169: CURSOR c_transfer_allowed_util IS
170: SELECT SUM(NVL(plan_curr_committed_amt,0)-NVL(plan_curr_utilized_amt,0)) total_amount
171: FROM ozf_object_fund_summary
172: WHERE object_id =p_object_id
173: AND object_type = p_object_type;
174:
175: /*

Line 447: -- 08/05/2005 feliu changed for R12 by using ozf_object_fund_summary.

443: -- money to fund the approved amount for a
444: -- budget request; return N, otherwise.
445: -- HISTORY
446: -- 20-Aug-2000 choang Created.
447: -- 08/05/2005 feliu changed for R12 by using ozf_object_fund_summary.
448: /*****************************************************************************************/
449: FUNCTION source_has_enough_money (
450: p_source_type IN VARCHAR2
451: ,p_source_id IN NUMBER

Line 465: FROM ozf_object_fund_summary

461: AND act_budget_used_by_id = p_source_id;
462: */
463: CURSOR c_approved_amount IS
464: SELECT SUM(NVL(committed_amt,0)-NVL(utilized_amt,0)) total_amount
465: FROM ozf_object_fund_summary
466: WHERE object_id =p_source_id
467: AND object_type = p_source_type;
468:
469: -- change by feliu on 03/26/04