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: --
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: --