APPS.OTA_TFH_API_BUSINESS_RULES2 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 16

Procedure update_finance_lines (p_rec in ota_tfh_api_shd.g_rec_type) is
--
l_proc  varchar2(72) := g_package||'update_finance_lines';

Line: 38

end update_finance_lines;

Line: 54

	select nvl(sum(tfl.money_amount),0)
	from ota_finance_lines tfl
	where finance_header_id = p_finance_header_id
	and cancelled_flag = 'N';