eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_CLAIM_LINE_PVT dependencies on OZF_CLAIM_LINES_UTIL_ALL

Line 5100: FROM ozf_claim_lines_util_all

5096:
5097: -- Fix for bug 7658894
5098: CURSOR csr_claim_line_util_sum(cv_claim_line_id IN NUMBER) IS
5099: SELECT sum(amount), sum(acctd_amount)
5100: FROM ozf_claim_lines_util_all
5101: WHERE claim_line_id = cv_claim_line_id;
5102:
5103: CURSOR csr_claim_line_sum(cv_claim_line_id IN NUMBER) IS
5104: SELECT nvl(amount,0), nvl(acctd_amount,0)

Line 5317: UPDATE ozf_claim_lines_util_all

5313:
5314: -- Point the utilizations to the new claim line
5315: IF l_util_product_id IS NULL AND l_util_product_level IS NULL THEN
5316: -- These are adjustment records without product info
5317: UPDATE ozf_claim_lines_util_all
5318: SET claim_line_id = l_claim_line_id
5319: WHERE claim_line_util_id IN ( SELECT util.claim_line_util_id
5320: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5321: WHERE fu.utilization_id = util.utilization_id

Line 5320: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util

5316: -- These are adjustment records without product info
5317: UPDATE ozf_claim_lines_util_all
5318: SET claim_line_id = l_claim_line_id
5319: WHERE claim_line_util_id IN ( SELECT util.claim_line_util_id
5320: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5321: WHERE fu.utilization_id = util.utilization_id
5322: AND fu.product_id IS NULL
5323: AND util.claim_line_id = p_claim_line_id
5324: AND fu.product_level_type IS NULL

Line 5328: UPDATE ozf_claim_lines_util_all

5324: AND fu.product_level_type IS NULL
5325: AND fu.plan_id = l_offer_id
5326: AND util.utilization_id > -1);
5327: ELSE
5328: UPDATE ozf_claim_lines_util_all
5329: SET claim_line_id = l_claim_line_id
5330: WHERE claim_line_util_id in ( SELECT util.claim_line_util_id
5331: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5332: WHERE fu.utilization_id = util.utilization_id

Line 5331: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util

5327: ELSE
5328: UPDATE ozf_claim_lines_util_all
5329: SET claim_line_id = l_claim_line_id
5330: WHERE claim_line_util_id in ( SELECT util.claim_line_util_id
5331: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5332: WHERE fu.utilization_id = util.utilization_id
5333: AND fu.product_id = l_util_product_id
5334: AND util.claim_line_id = p_claim_line_id
5335: AND fu.product_level_type = l_util_product_level

Line 5339: UPDATE ozf_claim_lines_util_all

5335: AND fu.product_level_type = l_util_product_level
5336: AND fu.plan_id = l_offer_id
5337: AND util.utilization_id > -1);
5338:
5339: UPDATE ozf_claim_lines_util_all
5340: SET claim_line_id = l_claim_line_id
5341: WHERE claim_line_util_id IN ( SELECT utl.claim_line_util_id
5342: FROM ams_act_products act, ozf_claim_lines_util_all utl
5343: WHERE utl.activity_product_id = act.activity_product_id

Line 5342: FROM ams_act_products act, ozf_claim_lines_util_all utl

5338:
5339: UPDATE ozf_claim_lines_util_all
5340: SET claim_line_id = l_claim_line_id
5341: WHERE claim_line_util_id IN ( SELECT utl.claim_line_util_id
5342: FROM ams_act_products act, ozf_claim_lines_util_all utl
5343: WHERE utl.activity_product_id = act.activity_product_id
5344: AND utl.claim_line_id = p_claim_line_id
5345: AND act.level_type_code = l_util_product_level
5346: AND NVL(act.inventory_item_id, act.category_id) = l_util_product_id