APPS.IPA_CLIENT_EXTENSION_PKG SQL Statements

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

Line: 17

        SELECT s.segment_name INTO name
          FROM fnd_id_flex_segments s,
               fnd_segment_attribute_values sav,
  	       fnd_segment_attribute_types sat
         WHERE s.application_id = appl_id
           AND s.id_flex_code = code
           AND s.id_flex_num = num
           AND s.enabled_flag = 'Y'
           AND s.application_column_name = sav.application_column_name
           AND sav.application_id = appl_id
           AND sav.id_flex_code = code
           AND sav.id_flex_num = num
           AND sav.attribute_value = 'Y'
           AND sav.segment_attribute_type = sat.segment_attribute_type
           AND sat.application_id = appl_id
           AND sat.id_flex_code = code
           AND sat.segment_attribute_type = qualifier;

Line: 69

        SELECT segment_num into seg_num
          FROM fnd_id_flex_segments
         WHERE application_id = appl_id
           AND id_flex_code = code
           AND id_flex_num = num
           AND segment_name = segment
           AND enabled_flag = 'Y';

Line: 81

        SELECT count(segment_num) INTO sequence
          FROM fnd_id_flex_segments
         WHERE application_id = appl_id
           AND id_flex_code = code
           AND id_flex_num = num
           AND enabled_flag = 'Y'
           AND segment_num <= seg_num;

Line: 139

     SELECT default_group_asset_id
     FROM   fa_category_books
     WHERE  category_id = p_asset_category_id
     AND    book_type_code = p_book_type_code;

Line: 146

     SELECT deprn_expense_acct_ccid
     FROM   fa_group_asset_default
     WHERE  book_type_code = p_book_type_code
     AND    group_asset_id = p_group_asset_id;

Line: 156

     SELECT group_asset_id
     FROM   fa_category_book_defaults
     WHERE  category_id = p_asset_category_id
     AND    book_type_code = p_book_type_code
     AND    trunc(SYSDATE) between start_dpis and nvl(end_dpis, TRUNC(SYSDATE));

Line: 164

     SELECT code_combination_id
     FROM   fa_distribution_history
     WHERE  asset_id = p_group_asset_id
     AND    transaction_header_id_out is null
     AND    rownum = 1;

Line: 220

    *  if dynamic insert is allowed
    **************************************************************************************/
procedure build_deprn_expense_acct(p_book_type_code in varchar2,
                                   p_asset_category_id in number,
                                   p_location_id in number default null,
                                   p_expenditure_item_id in number default null,
                                   p_expense_ccid_out in out NOCOPY number,
                                   p_err_stack in out NOCOPY varchar2,
                                   p_err_stage in out NOCOPY varchar2,
                                   p_err_code  in out NOCOPY varchar2)
is
Cursor c_appln is
select nvl(application_id,101)
from fnd_application
where application_short_name = 'SQLGL';

Line: 238

Select book_class,accounting_flex_structure,  flexbuilder_defaults_ccid
from fa_book_controls
where book_type_code = p_book_type_code;

Line: 244

select deprn_expense_acct
from fa_category_books
where category_id    = p_asset_category_id
and   book_type_code = p_book_type_code;

Line: 431

     SELECT 	pei.expenditure_type,pei.raw_cost,pei.quantity
     FROM   	pa_project_asset_lines ppal,
                pa_expenditure_items pei,
                pa_project_asset_line_details ppald
     WHERE      ppal.project_Asset_line_id = l_project_Asset_line_id
     AND        ppal.project_asset_line_detail_id= ppald.project_asset_line_detail_id
     AND        pei.expenditure_item_id = ppald.expenditure_item_id
     AND        ROWNUM=1;