APPS.OZF_CLAIM_SETTLEMENT_VAL_PVT dependencies on OZF_CLAIM_LINES_UTIL

Line 533: FROM ozf_claim_lines_util lu

529: AND claim_currency_amount <> 0;
530:
531: CURSOR csr_asso_offr_performance(cv_claim_line_id IN NUMBER) IS
532: SELECT op.offer_performance_id
533: FROM ozf_claim_lines_util lu
534: , ozf_funds_utilized fu
535: , ozf_offer_performances op
536: WHERE lu.utilization_id = fu.utilization_id
537: AND fu.component_type = 'OFFR'

Line 557: FROM ozf_claim_lines_util

553: -- Modified for FXGL Enhancement
554: -- Need to compare line amount with associated util_amounts
555: CURSOR csr_sum_util_amt(cv_claim_line_id IN NUMBER) IS
556: SELECT NVL(SUM(amount), 0)
557: FROM ozf_claim_lines_util
558: WHERE claim_line_id = cv_claim_line_id;
559:
560:
561: --//Bugfix : 13069412