APPS.OZF_CLAIM_LINE_PVT dependencies on OZF_CLAIM_LINES_UTIL_ALL

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: