APPS.PAY_US_W2_BOX_BAL SQL Statements

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

Line: 29

  PROCEDURE insert_w2_box_balances(errbuf out nocopy varchar2,
                                   retcode out nocopy number,
                                   p_w2_box_number  in varchar2,
                                   p_w2_box_code in varchar2,
                                   p_business_group_id in number) is

  /************************************************************
  ** Local Package Variables
  ************************************************************/

      lv_lookup_code    fnd_common_lookups.lookup_code%TYPE := null;

Line: 66

        ( SELECT balance_type_id
            FROM pay_balance_types
           WHERE balance_name = cp_balance_name
             AND   business_group_id = p_business_group_id);

Line: 74

      select 'x'
        from fnd_common_lookups
       where lookup_type = cp_lookup_type
         and lookup_code = cp_lookup_code
         and application_id = cp_application_id
         union
         select 'x'
        from fnd_common_lookups
       where lookup_type = 'W2 BOX 14'
         and lookup_code = cp_lookup_code
         and application_id = cp_application_id ;

Line: 88

     select 'y'
       from ff_user_entities fue
      where user_entity_name = cp_archive_dbi;

Line: 93

     select name from hr_organization_units
      where organization_id = cp_business_group_id;

Line: 177

         insert into fnd_lookup_values(lookup_type,
                                       language,
                                       lookup_code,
                                       meaning,
                                       description,
                                       enabled_flag,
                                       created_by,
                                       creation_date,
                                       last_updated_by,
                                       last_update_date,
                                       source_lang,
                                       view_application_id,
                                       last_update_login,
                                       ATTRIBUTE1,
                                       ATTRIBUTE2,
                                       ATTRIBUTE3)
                                 values(lv_lookup_type,
                                        lv_legislation,
                                        lv_lookup_code,
                                        lv_balance,
                                        lv_description,
                                        lv_enabled_flag,
                                        1,
                                        sysdate,
                                        2,
                                        sysdate,
                                        lv_legislation,
                                        3,
                                        0,
                                        'CP',
                                        lv_balance,
                                        lv_archive_dbi);

Line: 222

                   SELECT CATEGORY_NAME,EFFECTIVE_START_DATE into lv_category,l_start_date
                   FROM PAY_BALANCE_CATEGORIES_F
                   WHERE LEGISLATION_CODE = 'US'
                   AND CATEGORY_NAME = 'Information';

Line: 242

                              UPDATE pay_balance_types
                              SET BALANCE_CATEGORY_ID = ( SELECT BALANCE_CATEGORY_ID
                                                          FROM PAY_BALANCE_CATEGORIES_F
                                                          WHERE LEGISLATION_CODE = 'US'
                                                          AND CATEGORY_NAME = 'Information' )
                              WHERE balance_type_id = ln_bal_type_id;

Line: 261

              SELECT  count(0)
              INTO    ln_exists
              FROM    pay_defined_balances db,
                          pay_balance_dimensions dim
              WHERE   db.balance_type_id      = ln_bal_type_id
              AND     db.balance_dimension_id = dim.balance_dimension_id
              AND     dim.dimension_name      = lv_dimension;

Line: 336

  END; /*insert balances */