APPS.OZF_CLAIM_SETTLEMENT_VAL_PVT dependencies on OZF_CLAIM_LINES

Line 527: FROM ozf_claim_lines

523: , source_object_class
524: , source_object_id
525: , source_object_line_id
526: , item_id
527: FROM ozf_claim_lines
528: WHERE claim_id = cv_claim_id
529: AND claim_currency_amount <> 0;
530:
531: CURSOR csr_asso_offr_performance(cv_claim_line_id IN NUMBER) IS

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 545: FROM ozf_claim_lines ln

541: AND lu.claim_line_id = cv_claim_line_id;
542:
543: CURSOR csr_line_offr_performance(cv_claim_line_id IN NUMBER) IS
544: SELECT op.offer_performance_id
545: FROM ozf_claim_lines ln
546: , ozf_offer_performances op
547: WHERE ln.activity_type = 'OFFR'
548: AND ln.activity_id = op.list_header_id
549: AND (op.requirement_type IS NULL OR op.requirement_type NOT IN ('AMOUNT', 'VOLUME'))

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

Line 565: FROM ozf_claim_lines

561: --//Bugfix : 13069412
562: /*
563: CURSOR csr_sum_line_amt(cv_claim_id IN NUMBER) IS
564: SELECT NVL(SUM(claim_currency_amount), 0)
565: FROM ozf_claim_lines
566: WHERE claim_id = cv_claim_id;
567: */
568: CURSOR csr_sum_line_amt(cv_claim_id IN NUMBER) IS
569: SELECT NVL(SUM(claim_currency_amount), 0),NVL(SUM(claim_curr_tax_amount), 0)

Line 570: FROM ozf_claim_lines

566: WHERE claim_id = cv_claim_id;
567: */
568: CURSOR csr_sum_line_amt(cv_claim_id IN NUMBER) IS
569: SELECT NVL(SUM(claim_currency_amount), 0),NVL(SUM(claim_curr_tax_amount), 0)
570: FROM ozf_claim_lines
571: WHERE claim_id = cv_claim_id;
572:
573: --Added claim_currency_amount check for bug 6828924.
574: CURSOR csr_line_prom_distinct_chk(cv_claim_id IN NUMBER) IS

Line 576: FROM ozf_claim_lines

572:
573: --Added claim_currency_amount check for bug 6828924.
574: CURSOR csr_line_prom_distinct_chk(cv_claim_id IN NUMBER) IS
575: SELECT distinct earnings_associated_flag
576: FROM ozf_claim_lines
577: WHERE claim_id = cv_claim_id
578: AND claim_currency_amount <> 0;
579:
580: CURSOR csr_gl_date_validate(cv_app_id IN NUMBER, cv_set_of_books_id IN NUMBER) IS