DBA Data[Home] [Help]

APPS.OZF_SD_UTIL_PVT dependencies on OZF_SD_BATCH_HEADERS_ALL

Line 33: select currency_code into l_to_currency from ozf_sd_batch_headers_all

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);
36:
37: select exchange_rate_date into l_conv_date from OZF_FUNDS_UTILIZED_ALL_B where utilization_id=l_util_id;