DBA Data[Home] [Help]

APPS.OTA_TDB_BUS dependencies on OTA_FINANCE_LINES

Line 1245: from ota_finance_lines tfl

1241: Procedure check_finance_lines (p_booking_id in number) is
1242: --
1243: cursor c_check_finance_line is
1244: select nvl(sum(booking_id),0)
1245: from ota_finance_lines tfl
1246: where tfl.booking_id = p_booking_id;
1247: --
1248: l_finance_line_exists number;
1249: --

Line 1578: from ota_finance_lines tfl

1574: ,p_cancelled_flag in varchar2) return boolean is
1575: --
1576: cursor c_check_finance_line is
1577: select nvl(sum(booking_id),0)
1578: from ota_finance_lines tfl
1579: where tfl.booking_id = p_booking_id
1580: and tfl.cancelled_flag = p_cancelled_flag;
1581: l_finance_line_exists number;
1582: --