APPS.OZF_CLAIM_LINE_PVT dependencies on OZF_CLAIM_LINES_UTIL

Line 2606: FROM ozf_claim_lines_util

2602: CURSOR csr_get_lines_util(cv_claim_line_id IN NUMBER) IS
2603: SELECT claim_line_util_id
2604: , object_version_number
2605: , currency_code
2606: FROM ozf_claim_lines_util
2607: WHERE claim_line_id = cv_claim_line_id;
2608:
2609: l_claim_id NUMBER;
2610: l_claim_amount NUMBER;

Line 3476: FROM ozf_claim_lines_util

3472: -- Cursor to sum of line util associations
3473: -- Chage the cursor for bug 7658894
3474: CURSOR csr_claim_line_util_amt(cv_claim_line_id IN NUMBER) IS
3475: SELECT nvl(SUM(acctd_amount),0), nvl(SUM(amount),0)
3476: FROM ozf_claim_lines_util
3477: WHERE claim_line_id = cv_claim_line_id;
3478:
3479: -- Cursor to sum of claim line amount
3480: CURSOR c_line_sum_amt(cv_claim_id IN NUMBER, cv_line_id IN NUMBER) IS

Line 3509: FROM ozf_claim_lines_util

3505: CURSOR csr_get_lines_util(cv_claim_line_id IN NUMBER) IS
3506: SELECT claim_line_util_id
3507: , object_version_number
3508: , currency_code
3509: FROM ozf_claim_lines_util
3510: WHERE claim_line_id = cv_claim_line_id;
3511:
3512: -- Fix for bug 7658894
3513: l_line_util_sum NUMBER :=0;

Line 5500: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util utl

5496: fu.product_id product_id,
5497: utl.amount amount,
5498: utl.acctd_amount acctd_amount,
5499: utl.util_curr_amount util_curr_amount
5500: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util utl
5501: WHERE utl.utilization_id = fu.utilization_id
5502: AND utl.claim_line_id = cv_line_id
5503: AND utl.utilization_id <> -1
5504: UNION ALL

Line 5512: FROM ams_act_products act, ozf_claim_lines_util utl

5508: NVL(act.inventory_item_id, act.category_id) product_id,
5509: utl.amount amount,
5510: utl.acctd_amount acctd_amount,
5511: NVL(utl.util_curr_amount,utl.amount) util_curr_amount
5512: FROM ams_act_products act, ozf_claim_lines_util utl
5513: WHERE utl.activity_product_id = act.activity_product_id
5514: AND utl.claim_line_id = cv_line_id
5515: AND utl.utilization_id = -1)
5516: GROUP BY offer_id,activity_type, product_level_type, product_id;

Line 5533: FROM ozf_claim_lines_util_all

5529:
5530: -- Fix for bug 7658894
5531: CURSOR csr_claim_line_util_sum(cv_claim_line_id IN NUMBER) IS
5532: SELECT sum(amount), sum(acctd_amount)
5533: FROM ozf_claim_lines_util_all
5534: WHERE claim_line_id = cv_claim_line_id;
5535:
5536: CURSOR csr_claim_line_sum(cv_claim_line_id IN NUMBER) IS
5537: SELECT nvl(amount,0), nvl(acctd_amount,0)

Line 5750: UPDATE ozf_claim_lines_util_all

5746:
5747: -- Point the utilizations to the new claim line
5748: IF l_util_product_id IS NULL AND l_util_product_level IS NULL THEN
5749: -- These are adjustment records without product info
5750: UPDATE ozf_claim_lines_util_all
5751: SET claim_line_id = l_claim_line_id
5752: WHERE claim_line_util_id IN ( SELECT util.claim_line_util_id
5753: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5754: WHERE fu.utilization_id = util.utilization_id

Line 5753: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util

5749: -- These are adjustment records without product info
5750: UPDATE ozf_claim_lines_util_all
5751: SET claim_line_id = l_claim_line_id
5752: WHERE claim_line_util_id IN ( SELECT util.claim_line_util_id
5753: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5754: WHERE fu.utilization_id = util.utilization_id
5755: AND fu.product_id IS NULL
5756: AND util.claim_line_id = p_claim_line_id
5757: AND fu.product_level_type IS NULL

Line 5761: UPDATE ozf_claim_lines_util_all

5757: AND fu.product_level_type IS NULL
5758: AND fu.plan_id = l_offer_id
5759: AND util.utilization_id > -1);
5760: ELSE
5761: UPDATE ozf_claim_lines_util_all
5762: SET claim_line_id = l_claim_line_id
5763: WHERE claim_line_util_id in ( SELECT util.claim_line_util_id
5764: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5765: WHERE fu.utilization_id = util.utilization_id

Line 5764: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util

5760: ELSE
5761: UPDATE ozf_claim_lines_util_all
5762: SET claim_line_id = l_claim_line_id
5763: WHERE claim_line_util_id in ( SELECT util.claim_line_util_id
5764: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5765: WHERE fu.utilization_id = util.utilization_id
5766: AND fu.product_id = l_util_product_id
5767: AND util.claim_line_id = p_claim_line_id
5768: AND fu.product_level_type = l_util_product_level

Line 5772: UPDATE ozf_claim_lines_util_all

5768: AND fu.product_level_type = l_util_product_level
5769: AND fu.plan_id = l_offer_id
5770: AND util.utilization_id > -1);
5771:
5772: UPDATE ozf_claim_lines_util_all
5773: SET claim_line_id = l_claim_line_id
5774: WHERE claim_line_util_id IN ( SELECT utl.claim_line_util_id
5775: FROM ams_act_products act, ozf_claim_lines_util_all utl
5776: WHERE utl.activity_product_id = act.activity_product_id

Line 5775: FROM ams_act_products act, ozf_claim_lines_util_all utl

5771:
5772: UPDATE ozf_claim_lines_util_all
5773: SET claim_line_id = l_claim_line_id
5774: WHERE claim_line_util_id IN ( SELECT utl.claim_line_util_id
5775: FROM ams_act_products act, ozf_claim_lines_util_all utl
5776: WHERE utl.activity_product_id = act.activity_product_id
5777: AND utl.claim_line_id = p_claim_line_id
5778: AND act.level_type_code = l_util_product_level
5779: AND NVL(act.inventory_item_id, act.category_id) = l_util_product_id

Line 5909: FROM ozf_claim_lines_all cln, ozf_claim_lines_util_all clu

5905:
5906: --Cursor to fetch the claim line detail
5907: CURSOR claim_line_id_csr(p_id in number) IS
5908: SELECT distinct cln.claim_line_id, cln.object_version_number
5909: FROM ozf_claim_lines_all cln, ozf_claim_lines_util_all clu
5910: WHERE clu.claim_line_id = cln.claim_line_id
5911: AND claim_id = p_id;
5912:
5913: