APPS.FA_MASSADD_PREP_DEFAULT_PKG SQL Statements

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

Line: 39

    Select sob.chart_of_accounts_id
      into h_chart_of_accounts_id
      From fa_book_controls bc, gl_sets_of_books sob
     Where sob.set_of_books_id = bc.set_of_books_id
       And bc.book_type_code = px_mass_add_rec.book_type_code;

Line: 64

      select ACCOUNTING_FLEX_STRUCTURE
        into l_ACCOUNTING_FLEX_STRUCTURE
        from fa_book_controls
       where book_type_code = px_mass_add_rec.BOOK_TYPE_CODE;

Line: 80

      select Segment1,
             Segment2,
             Segment3,
             Segment4,
             Segment5,
             Segment6,
             Segment7,
             Segment8,
             Segment9,
             Segment10,
             Segment11,
             Segment12,
             Segment13,
             Segment14,
             Segment15,
             Segment16,
             Segment17,
             Segment18,
             Segment19,
             Segment20,
             Segment21,
             Segment22,
             Segment23,
             Segment24,
             Segment25,
             Segment26,
             Segment27,
             Segment28,
             Segment29,
             Segment30,
             enabled_flag
        into l_segment(1),
             l_segment(2),
             l_segment(3),
             l_segment(4),
             l_segment(5),
             l_segment(6),
             l_segment(7),
             l_segment(8),
             l_segment(9),
             l_segment(10),
             l_segment(11),
             l_segment(12),
             l_segment(13),
             l_segment(14),
             l_segment(15),
             l_segment(16),
             l_segment(17),
             l_segment(18),
             l_segment(19),
             l_segment(20),
             l_segment(21),
             l_segment(22),
             l_segment(23),
             l_segment(24),
             l_segment(25),
             l_segment(26),
             l_segment(27),
             l_segment(28),
             l_segment(29),
             l_segment(30),
             l_gl_ccid_enabled_flag
        from gl_code_combinations
        where code_combination_id =
             px_mass_add_rec.payables_code_combination_id
        and CHART_OF_ACCOUNTS_ID = h_chart_of_accounts_id;

Line: 175

        select category_id
          into px_mass_add_rec.ASSET_CATEGORY_ID
          from fa_category_books
         where ASSET_CLEARING_ACCT = l_asset_clearing_acct
           and book_type_code = px_mass_add_rec.book_type_code
           and rownum = 1;

Line: 190

        select category_id
          into px_mass_add_rec.ASSET_CATEGORY_ID
          from fa_category_books
         where CIP_CLEARING_ACCT = l_asset_clearing_acct
           and book_type_code = px_mass_add_rec.book_type_code
           and rownum = 1;

Line: 261

    select FLEXBUILDER_DEFAULTS_CCID
    into l_default_ccid
    from fa_book_controls
    where book_type_code = px_mass_add_rec.book_type_code;

Line: 266

    SELECT deprn_expense_acct,
           asset_cost_account_ccid,
           ASSET_CLEARING_ACCOUNT_CCID
    INTO   h_new_deprn_exp_acct,
           h_cost_acct_ccid,
           h_cost_clearing_acct_ccid
    FROM
           fa_category_books
    WHERE  book_type_code = px_mass_add_rec.book_type_code
    AND    category_id = px_mass_add_rec.asset_category_id;

Line: 278

    Select  sob.chart_of_accounts_id
    into    h_chart_of_accounts_id
    From    fa_book_controls bc,
            gl_sets_of_books sob
    Where   sob.set_of_books_id = bc.set_of_books_id
    And     bc.book_type_code  = px_mass_add_rec.book_type_code;