APPS.OTA_TFL_API_BUSINESS_RULES SQL Statements

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

Line: 231

    select customer_id,receivable_type
      from ota_finance_headers
     where finance_header_id     =    p_finance_header_id;

Line: 236

    select customer_id,type,number_of_places,limit_each_event_flag
      from ota_booking_deals
     where booking_deal_id       =    p_booking_deal_id;

Line: 288

    select tsr.vendor_id
      from ota_resource_bookings     trb
         , ota_suppliable_resources  tsr
     where trb.resource_booking_id   =    p_resource_booking_id
       and tsr.supplied_resource_id  =    trb.supplied_resource_id;

Line: 295

    select tfh.vendor_id
      from ota_finance_headers       tfh
     where tfh.finance_header_id     =    p_finance_header_id;

Line: 375

    select tdb.customer_id
         , tdb.source_of_booking
      from ota_resource_allocations    tra
         , ota_delegate_bookings       tdb
     where tra.resource_allocation_id  =  p_resource_allocation_id
       and tdb.booking_id              =  tra.booking_id;

Line: 383

    select tfh.customer_id
      from ota_finance_headers         tfh
     where tfh.finance_header_id       =  p_finance_header_id;

Line: 472

    select tdb.customer_id
         , tdb.source_of_booking
      from ota_delegate_bookings     tdb
     where tdb.booking_id            =    p_booking_id;

Line: 478

    select tfh.customer_id
      from ota_finance_headers       tfh
     where tfh.finance_header_id     =    p_finance_header_id;

Line: 571

    select tbd.type
         , tpl.price_list_type
      from ota_booking_deals      tbd
         , ota_price_lists        tpl
     where tbd.booking_deal_id    =  p_booking_deal_id
       and tpl.price_list_id  (+) =  tbd.price_list_id;

Line: 638

    select type
    from   OTA_FINANCE_HEADERS
    where  finance_header_id = p_finance_header_id;

Line: 734

    SELECT type
    FROM ota_finance_headers
    WHERE finance_header_id = p_finance_header_id;

Line: 800

Procedure check_update_attributes
  (
   p_transfer_status      in   varchar2
  ) is
  --
  v_proc                  varchar2(72) := g_package||'check_update_attributes';

Line: 813

          fnd_message.set_name('OTA','OTA_13355_TFL_UPDATE');

Line: 820

End check_update_attributes;

Line: 866

    select 'Y'
      from ota_finance_lines         tfl
     where tfl.finance_header_id     =    p_finance_header_id
       and tfl.sequence_number       =    p_sequence_number;

Line: 925

    select nvl( max( tfl.sequence_number), 0)
      from ota_finance_lines         tfl
     where tfl.finance_header_id     =    p_finance_header_id;

Line: 980

    select tfh.date_raised
      from ota_finance_headers       tfh
     where tfh.finance_header_id     =    p_finance_header_id;

Line: 1026

Procedure check_delete_attempt
  (
   p_finance_header_id       in   number
  ,p_finance_line_id         in   number
  ) is
  --
  v_proc                  varchar2(72) := g_package||'check_delete_attempt';

Line: 1038

          fnd_message.set_name('OTA','OTA_13357_TFL_DELETE');

Line: 1043

End check_delete_attempt;

Line: 1068

    select tfh.currency_code,tfh.type
      from ota_finance_headers       tfh
     where tfh.finance_header_id     =    p_finance_header_id;

Line: 1073

    select evt.currency_code
      from ota_delegate_bookings     tdb
         , ota_events                evt
     where tdb.booking_id            =    p_booking_id
       and evt.event_id              =    tdb.event_id;

Line: 1080

    select tpl.currency_code
      from ota_booking_deals         tbd
         , ota_price_lists           tpl
     where tbd.booking_deal_id       =    p_booking_deal_id
       and tpl.price_list_id         =    tbd.price_list_id;

Line: 1087

    select evt.currency_code
      from ota_resource_allocations   tra
         , ota_delegate_bookings      tdb
         , ota_events                 evt
     where tra.resource_allocation_id =   p_resource_allocation_id
       and tdb.booking_id             =   tra.booking_id
       and evt.event_id               =   tdb.event_id;

Line: 1096

   select tsr.currency_code
    from ota_suppliable_resources tsr,
	 ota_resource_bookings trb
    where tsr.supplied_resource_id = trb.supplied_resource_id
    and trb.resource_booking_id = p_resource_booking_id;

Line: 1102

   /* select decode(evt.event_id,'',v_header_currency_code
                              ,evt.currency_code)
      from ota_resource_bookings     trb
         , ota_events                evt
     where trb.resource_booking_id   =    p_resource_booking_id
       and evt.event_id(+)           =    trb.event_id;*/

Line: 1240

    select evt.currency_code
      from ota_delegate_bookings     tdb
         , ota_events                evt
     where tdb.booking_id            =    p_booking_id
       and evt.event_id              =    tdb.event_id;

Line: 1247

    select tpl.currency_code
      from ota_booking_deals         tbd
         , ota_price_lists           tpl
     where tbd.booking_deal_id       =    p_booking_deal_id
       and tpl.price_list_id         =    tbd.price_list_id;

Line: 1254

    select evt.currency_code
      from ota_resource_allocations   tra
         , ota_delegate_bookings      tdb
         , ota_events                 evt
     where tra.resource_allocation_id =   p_resource_allocation_id
       and tdb.booking_id             =   tra.booking_id
       and evt.event_id               =   tdb.event_id;

Line: 1263

    select evt.currency_code
      from ota_resource_bookings     trb
         , ota_events                evt
     where trb.resource_booking_id   =    p_resource_booking_id
       and evt.event_id              =    trb.event_id;

Line: 1377

    select tfh.type,tfh.receivable_type
      from ota_finance_headers       tfh
     where tfh.finance_header_id     =    p_finance_header_id;

Line: 1431

select finance_line_id
from   ota_finance_lines
where  (p_finance_line_id is null
     or p_finance_line_id <> finance_line_id)
and    cancelled_flag = 'N'
and  ((p_line_type = 'E' and
       booking_id = p_booking_id)
  or  (p_line_type = 'R' and
       resource_allocation_id = p_resource_allocation_id)
  or  (p_line_type = 'V'   and
       resource_booking_id = p_resource_booking_id));

Line: 1482

select type
,      customer_id
,      vendor_id
,      receivable_type
,      transfer_status
,      cancelled_flag
from   ota_finance_headers
where finance_header_id = p_finance_header_id;

Line: 1492

select 'Y'
from ota_finance_headers
where superceding_header_id = p_finance_header_id;

Line: 1543

        for the lines to be processed has already been updated with
        Cancelled_flag = 'Y' and Transfer Status = 'ST' and
        Superseded_flag = 'Y'. We therefore do not want to repeat checks on
        these attributes.
*/
if p_check_successful_transfer then
  hr_utility.trace('Superseded Flag = '||p_superseded_flag);