APPS.OZF_CLAIM_SETTLEMENT_VAL_PVT dependencies on OZF_CLAIM_LINES

Line 496: FROM ozf_claim_lines

492: , source_object_class
493: , source_object_id
494: , source_object_line_id
495: , item_id
496: FROM ozf_claim_lines
497: WHERE claim_id = cv_claim_id
498: AND claim_currency_amount <> 0;
499:
500: CURSOR csr_asso_offr_performance(cv_claim_line_id IN NUMBER) IS

Line 502: FROM ozf_claim_lines_util lu

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'

Line 514: FROM ozf_claim_lines ln

510: AND lu.claim_line_id = cv_claim_line_id;
511:
512: CURSOR csr_line_offr_performance(cv_claim_line_id IN NUMBER) IS
513: SELECT op.offer_performance_id
514: FROM ozf_claim_lines ln
515: , ozf_offer_performances op
516: WHERE ln.activity_type = 'OFFR'
517: AND ln.activity_id = op.list_header_id
518: AND (op.requirement_type IS NULL OR op.requirement_type NOT IN ('AMOUNT', 'VOLUME'))

Line 526: FROM ozf_claim_lines_util

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)

Line 531: FROM ozf_claim_lines

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)
531: FROM ozf_claim_lines
532: WHERE claim_id = cv_claim_id;
533:
534: --Added claim_currency_amount check for bug 6828924.
535: CURSOR csr_line_prom_distinct_chk(cv_claim_id IN NUMBER) IS

Line 537: FROM ozf_claim_lines

533:
534: --Added claim_currency_amount check for bug 6828924.
535: CURSOR csr_line_prom_distinct_chk(cv_claim_id IN NUMBER) IS
536: SELECT distinct earnings_associated_flag
537: FROM ozf_claim_lines
538: WHERE claim_id = cv_claim_id
539: AND claim_currency_amount <> 0;
540:
541: CURSOR csr_gl_date_validate(cv_app_id IN NUMBER, cv_set_of_books_id IN NUMBER) IS