APPS.OZF_UTILITY_PVT dependencies on OZF_OBJECT_FUND_SUMMARY

Line 3331: FROM ozf_object_fund_summary

3327: p_committed_amount NUMBER := 0;
3328:
3329: CURSOR curr_committed_amount(list_header_id NUMBER) IS
3330: SELECT SUM(NVL(plan_curr_committed_amt,0))
3331: FROM ozf_object_fund_summary
3332: WHERE object_id = list_header_id
3333: AND object_type = 'OFFR';
3334: /*
3335: SELECT SUM(AMOUNT)

Line 3382: FROM ozf_object_fund_summary

3378: p_committed_amount NUMBER := 0;
3379:
3380: CURSOR curr_committed_amount(list_header_id NUMBER) IS
3381: SELECT SUM(NVL(plan_curr_recal_committed_amt,0))
3382: FROM ozf_object_fund_summary
3383: WHERE object_id = list_header_id
3384: AND object_type = 'OFFR';
3385: /*
3386: SELECT SUM(AMOUNT)

Line 3419: FROM ozf_object_fund_summary

3415: p_utilized_amount NUMBER := 0;
3416:
3417: CURSOR curr_utilized_amount(list_header_id NUMBER) IS
3418: SELECT SUM(NVL(plan_curr_utilized_amt,0))
3419: FROM ozf_object_fund_summary
3420: WHERE object_id = list_header_id
3421: AND object_type = 'OFFR';
3422:
3423: /*

Line 3460: FROM ozf_object_fund_summary

3456: p_earned_amount NUMBER := 0;
3457:
3458: CURSOR curr_earned_amount(list_header_id NUMBER) IS
3459: SELECT SUM(NVL(plan_curr_earned_amt,0))
3460: FROM ozf_object_fund_summary
3461: WHERE object_id = list_header_id
3462: AND object_type = 'OFFR';
3463: /*
3464: SELECT SUM(uti.plan_curr_amount)

Line 3501: FROM ozf_object_fund_summary

3497: p_paid_amount NUMBER := 0;
3498:
3499: CURSOR curr_paid_amount(list_header_id NUMBER) IS
3500: SELECT SUM(NVL(plan_curr_paid_amt,0))
3501: FROM ozf_object_fund_summary
3502: WHERE object_id = list_header_id
3503: AND object_type = 'OFFR';
3504:
3505: /*