[Home] [Help]
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';