APPS.OZF_SD_UTIL_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 31: -- select currency_code into l_from_currency from OZF_FUNDS_UTILIZED_ALL_B where utilization_id=l_util_id;

27: begin
28:
29: select UTILIZATION_ID,CLAIM_AMOUNT_CURRENCY_CODE into l_util_id,l_from_currency from OZF_SD_BATCH_LINES_ALL where batch_line_id=p_batch_line_id;
30:
31: -- select currency_code into l_from_currency from OZF_FUNDS_UTILIZED_ALL_B where utilization_id=l_util_id;
32:
33: select currency_code into l_to_currency from ozf_sd_batch_headers_all
34: where batch_id=(select batch_id from ozf_sd_batch_lines_all
35: where batch_line_id = p_batch_line_id);

Line 37: select exchange_rate_date into l_conv_date from OZF_FUNDS_UTILIZED_ALL_B where utilization_id=l_util_id;

33: select currency_code into l_to_currency from ozf_sd_batch_headers_all
34: where batch_id=(select batch_id from ozf_sd_batch_lines_all
35: where batch_line_id = p_batch_line_id);
36:
37: select exchange_rate_date into l_conv_date from OZF_FUNDS_UTILIZED_ALL_B where utilization_id=l_util_id;
38:
39: OZF_UTILITY_PVT.Convert_Currency (
40: x_return_status ,
41: l_from_currency ,

Line 71: UPDATE OZF_FUNDS_UTILIZED_ALL_B

67: where batch_line_id=p_batch_line_id;
68:
69:
70:
71: UPDATE OZF_FUNDS_UTILIZED_ALL_B
72: SET amount_remaining=amount_remaining+l_amount_remaining,
73: PLAN_CURR_AMOUNT_REMAINING=PLAN_CURR_AMOUNT_REMAINING+l_claim_amount,
74: acctd_amount_remaining=acctd_amount_remaining+l_acctd_amount_remaining,
75: univ_curr_amount_remaining=univ_curr_amount_remaining+l_amount_remaining