APPS.OZF_CLAIM_SETTLEMENT_PVT dependencies on OZF_CLAIM_LINES_UTIL_ALL

Line 2327: , ozf_claim_lines_util_all lu

2323: , fu.exchange_rate_type
2324: , fu.exchange_rate
2325: , fu.exchange_rate_date
2326: FROM ozf_claim_lines_all ln
2327: , ozf_claim_lines_util_all lu
2328: , ozf_funds_utilized_all_b fu
2329: WHERE ln.claim_id = p_claim_id
2330: AND ln.claim_line_id = lu.claim_line_id
2331: AND lu.utilization_id = fu.utilization_id;

Line 2376: UPDATE ozf_claim_lines_util_all

2372: IF (p_claim_rate = 1) THEN
2373:
2374: p_claim_exchange_date := l_claim_settled_date;
2375: -- Update the claim line util table with the settled date.
2376: UPDATE ozf_claim_lines_util_all
2377: SET exchange_rate_date = l_claim_settled_date
2378: WHERE claim_line_util_id = l_line_util_id;
2379:
2380: END IF;

Line 2447: UPDATE ozf_claim_lines_util_all

2443: OZF_Utility_PVT.debug_message('l_claim_settled_date = '||l_claim_settled_date);
2444: OZF_Utility_PVT.debug_message('l_claim_exc_rate = '||l_claim_exc_rate);
2445: END IF;
2446:
2447: UPDATE ozf_claim_lines_util_all
2448: SET acctd_amount = l_lu_acctd_amount
2449: , exchange_rate_date = l_claim_settled_date
2450: , exchange_rate = l_claim_exc_rate
2451: -- , utilized_acctd_amount = l_util_acctd_amount