APPS.OZF_OFFER_PVT dependencies on OZF_OBJECT_CHECKBOOK_V

Line 400: FROM ozf_object_checkbook_v

396: p_committed_amount NUMBER := 0;
397:
398: CURSOR curr_committed_amount(list_header_id NUMBER) IS
399: SELECT SUM(DECODE(recal_flag, 'N',committed_amt)) committed_amount
400: FROM ozf_object_checkbook_v
401: WHERE object_id = list_header_id
402: AND object_type = 'OFFR';
403:
404: BEGIN

Line 423: FROM ozf_object_checkbook_v

419: p_committed_amount NUMBER := 0;
420:
421: CURSOR curr_committed_amount(list_header_id NUMBER) IS
422: SELECT SUM(committed_amt) recal_committed_amount
423: FROM ozf_object_checkbook_v
424: WHERE object_id = list_header_id
425: AND object_type = 'OFFR';
426:
427: BEGIN

Line 445: FROM ozf_object_checkbook_v

441: p_earned_amount NUMBER := 0;
442:
443: CURSOR curr_earned_amount(list_header_id NUMBER) IS
444: SELECT NVL(SUM(NVL(utilized_amt,0)),0) utlized_amount
445: FROM ozf_object_checkbook_v
446: WHERE object_id = list_header_id
447: AND object_type = 'OFFR';
448:
449: BEGIN

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

462: IS
463: p_paid_amount NUMBER := 0;
464:
465: CURSOR curr_paid_amount(list_header_id NUMBER) IS
466: SELECT NVL(SUM(NVL(paid_amt,0)),0) paid_amount FROM ozf_object_checkbook_v
467: WHERE object_id = list_header_id
468: AND object_type = 'OFFR';
469:
470: BEGIN