APPS.OZF_OFFER_PVT dependencies on OZF_OBJECT_CHECKBOOK_V

Line 336: FROM ozf_object_checkbook_v

332: p_committed_amount NUMBER := 0;
333:
334: CURSOR curr_committed_amount(list_header_id NUMBER) IS
335: SELECT SUM(DECODE(recal_flag, 'N',committed_amt)) committed_amount
336: FROM ozf_object_checkbook_v
337: WHERE object_id = list_header_id
338: AND object_type = 'OFFR';
339:
340: BEGIN

Line 359: FROM ozf_object_checkbook_v

355: p_committed_amount NUMBER := 0;
356:
357: CURSOR curr_committed_amount(list_header_id NUMBER) IS
358: SELECT SUM(committed_amt) recal_committed_amount
359: FROM ozf_object_checkbook_v
360: WHERE object_id = list_header_id
361: AND object_type = 'OFFR';
362:
363: BEGIN

Line 381: FROM ozf_object_checkbook_v

377: p_earned_amount NUMBER := 0;
378:
379: CURSOR curr_earned_amount(list_header_id NUMBER) IS
380: SELECT NVL(SUM(NVL(utilized_amt,0)),0) utlized_amount
381: FROM ozf_object_checkbook_v
382: WHERE object_id = list_header_id
383: AND object_type = 'OFFR';
384:
385: BEGIN

Line 402: SELECT NVL(SUM(NVL(paid_amt,0)),0) paid_amount FROM ozf_object_checkbook_v

398: IS
399: p_paid_amount NUMBER := 0;
400:
401: CURSOR curr_paid_amount(list_header_id NUMBER) IS
402: SELECT NVL(SUM(NVL(paid_amt,0)),0) paid_amount FROM ozf_object_checkbook_v
403: WHERE object_id = list_header_id
404: AND object_type = 'OFFR';
405:
406: BEGIN