APPS.OZF_UTILITY_PVT dependencies on OZF_OBJECT_FUND_SUMMARY

Line 3309: FROM ozf_object_fund_summary

3305: p_committed_amount NUMBER := 0;
3306:
3307: CURSOR curr_committed_amount(list_header_id NUMBER) IS
3308: SELECT SUM(NVL(plan_curr_committed_amt,0))
3309: FROM ozf_object_fund_summary
3310: WHERE object_id = list_header_id
3311: AND object_type = 'OFFR';
3312: /*
3313: SELECT SUM(AMOUNT)

Line 3360: FROM ozf_object_fund_summary

3356: p_committed_amount NUMBER := 0;
3357:
3358: CURSOR curr_committed_amount(list_header_id NUMBER) IS
3359: SELECT SUM(NVL(plan_curr_recal_committed_amt,0))
3360: FROM ozf_object_fund_summary
3361: WHERE object_id = list_header_id
3362: AND object_type = 'OFFR';
3363: /*
3364: SELECT SUM(AMOUNT)

Line 3397: FROM ozf_object_fund_summary

3393: p_utilized_amount NUMBER := 0;
3394:
3395: CURSOR curr_utilized_amount(list_header_id NUMBER) IS
3396: SELECT SUM(NVL(plan_curr_utilized_amt,0))
3397: FROM ozf_object_fund_summary
3398: WHERE object_id = list_header_id
3399: AND object_type = 'OFFR';
3400:
3401: /*

Line 3438: FROM ozf_object_fund_summary

3434: p_earned_amount NUMBER := 0;
3435:
3436: CURSOR curr_earned_amount(list_header_id NUMBER) IS
3437: SELECT SUM(NVL(plan_curr_earned_amt,0))
3438: FROM ozf_object_fund_summary
3439: WHERE object_id = list_header_id
3440: AND object_type = 'OFFR';
3441: /*
3442: SELECT SUM(uti.plan_curr_amount)

Line 3479: FROM ozf_object_fund_summary

3475: p_paid_amount NUMBER := 0;
3476:
3477: CURSOR curr_paid_amount(list_header_id NUMBER) IS
3478: SELECT SUM(NVL(plan_curr_paid_amt,0))
3479: FROM ozf_object_fund_summary
3480: WHERE object_id = list_header_id
3481: AND object_type = 'OFFR';
3482:
3483: /*