eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TFL_API_BUSINESS_RULES dependencies on OTA_FINANCE_LINES

Line 867: from ota_finance_lines tfl

863: v_proc varchar2(72) := g_package||'check_sequence_number';
864: --
865: cursor sel_sequence_number is
866: select 'Y'
867: from ota_finance_lines tfl
868: where tfl.finance_header_id = p_finance_header_id
869: and tfl.sequence_number = p_sequence_number;
870: --
871: Begin

Line 926: from ota_finance_lines tfl

922: v_proc varchar2(72) := g_package||'get_next_sequence_number';
923: --
924: cursor get_sequence_number is
925: select nvl( max( tfl.sequence_number), 0)
926: from ota_finance_lines tfl
927: where tfl.finance_header_id = p_finance_header_id;
928: --
929: Begin
930: --

Line 1432: from ota_finance_lines

1428: l_finance_line_id number;
1429: --
1430: cursor find_other_lines is
1431: select finance_line_id
1432: from ota_finance_lines
1433: where (p_finance_line_id is null
1434: or p_finance_line_id <> finance_line_id)
1435: and cancelled_flag = 'N'
1436: and ((p_line_type = 'E' and