498: AND claim_currency_amount <> 0;
499:
500: CURSOR csr_asso_offr_performance(cv_claim_line_id IN NUMBER) IS
501: SELECT op.offer_performance_id
502: FROM ozf_claim_lines_util lu
503: , ozf_funds_utilized fu
504: , ozf_offer_performances op
505: WHERE lu.utilization_id = fu.utilization_id
506: AND fu.component_type = 'OFFR'
522: -- Modified for FXGL Enhancement
523: -- Need to compare line amount with associated util_amounts
524: CURSOR csr_sum_util_amt(cv_claim_line_id IN NUMBER) IS
525: SELECT NVL(SUM(amount), 0)
526: FROM ozf_claim_lines_util
527: WHERE claim_line_id = cv_claim_line_id;
528:
529: CURSOR csr_sum_line_amt(cv_claim_id IN NUMBER) IS
530: SELECT NVL(SUM(claim_currency_amount), 0)