APPS.OTA_FINANCE SQL Statements

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

Line: 65

                   p_transaction_type      => 'INSERT');

Line: 75

Procedure update_finance_line ( p_finance_header_id     in number default null,
                                p_finance_line_id       in number,
                                p_object_version_number in out number,
                                p_standard_amount       in number default null,
                                p_unitary_amount        in number default null,
                                p_money_amount          in number default null,
                                p_booking_deal_id       in number default null
                              ) is
  --
  l_sequence_number number;

Line: 86

  l_proc            varchar2(72) := g_package||'update_finance_line';

Line: 101

                   p_transaction_type      => 'UPDATE');

Line: 104

End update_finance_line;

Line: 131

    select null
    from   ota_finance_headers
    where  finance_header_id = p_finance_header_id
    and    receivable_type = 'PRE-PURCHASE USE';

Line: 196

    update_finance_line ( p_finance_header_id     => p_finance_header_id,
                          p_finance_line_id       => p_finance_line_id,
                          p_object_version_number => p_object_version_number,
                          p_standard_amount       => p_standard_amount,
                          p_unitary_amount        => p_unitary_amount,
                          p_money_amount          => p_money_amount,
                          p_booking_deal_id       => p_booking_deal_id);

Line: 214

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