APPS.PAY_ASSOC_BAL SQL Statements

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

Line: 35

10-Dec-04       Fusman          Added retro_element Procedure to update
                                all the seeded US earnings with the default
                                event group.
29-Apr-05       rdhingra        Added procedure map_time_definition to stamp
                                PAY_US_TIME_DEFINITIONS value set id onto
                                the information element.
10-may-05       djoshi    115.6 Modified sql to get the event group.
                                for 'Entry Changes' event we need to
                                look if Core event Group exist
                                and for Regular Earnings' we
                                need to make sure we have US
                                event. Added legislation_code = null
                                and Business Group id = NUll for
                                core and Added legislation = 'US'
                                for  Regular Earnings' event.
12-FEB-2009    tclewis    115.7 Added SDI1 EE Wthiheld and Taxable

31-MAY-2012    rmugloo    115.8 Bug 14070745 : Added "Workers Compensation2 ER" as primary
                                balance for "Workers Compensation2 ER" element and
                                "Workers Compensation3 ER" as primary balance for
                                "Workers Compensation3 ER" element.

--
DESCRIPTION

This is a post install step to be run when the installation of startup
elements and balances has occurred.
Select installed balance and element type ids BY NAME; associate balances

Line: 73

      SELECT element_type_id
        FROM pay_element_types_f
       WHERE UPPER (element_name) = UPPER (l_element_name)
         AND business_group_id IS NULL
         AND legislation_code = 'US';

Line: 84

      SELECT input_value_id
        FROM pay_input_values_f
       WHERE element_type_id = l_element_type_id
         AND UPPER (NAME) = UPPER (l_input_value_name)
         AND business_group_id IS NULL
         AND legislation_code = 'US';

Line: 93

      SELECT flex_value_set_id
        FROM fnd_flex_value_sets
       WHERE validation_type = 'F'
         AND UPPER (flex_value_set_name) = UPPER (l_flex_value_set_name);

Line: 132

	    UPDATE pay_input_values_f
               SET value_set_id = l_flex_value_set_id
             WHERE input_value_id = l_input_value_id
               AND business_group_id IS NULL
               AND legislation_code = 'US';

Line: 167

 SELECT  element_type_id
 INTO    l_eletype_id
 FROM    pay_element_types_f
 WHERE   UPPER(element_name) = UPPER(p_element_name)
 AND     business_group_id IS NULL
 AND     legislation_code = 'US';

Line: 180

update pay_element_types_f
  set RECALC_EVENT_GROUP_ID = p_event_group_id
  where element_type_id = l_eletype_id
  and business_group_id is null
  and legislation_code = 'US';

Line: 213

 SELECT	element_type_id
 INTO	v_eletype_id
 FROM	pay_element_types_f
 WHERE 	UPPER(element_name) = UPPER(p_element_name)
 AND	business_group_id IS NULL
 AND	legislation_code = 'US';

Line: 221

  SELECT	balance_type_id
  INTO		v_baltype_id
  FROM		pay_balance_types
  WHERE 	UPPER(balance_name) = UPPER(p_balance_name)
  AND		business_group_id IS NULL
  AND		legislation_code = 'US';

Line: 237

  update pay_element_types_f
  set ELEMENT_INFORMATION10 = v_baltype_id
  where element_type_id = v_eletype_id
  and business_group_id is null
  and legislation_code = 'US';

Line: 246

  update pay_element_types_f
  set ELEMENT_INFORMATION11 = v_baltype_id
  where element_type_id = v_eletype_id
  and business_group_id is null
  and legislation_code = 'US';

Line: 255

  update pay_element_types_f
  set ELEMENT_INFORMATION12 = v_baltype_id
  where element_type_id = v_eletype_id
  and business_group_id is null
  and legislation_code = 'US';

Line: 264

  update pay_element_types_f
  set ELEMENT_INFORMATION13 = v_baltype_id
  where element_type_id = v_eletype_id
  and business_group_id is null
  and legislation_code = 'US';

Line: 273

  update pay_element_types_f
  set ELEMENT_INFORMATION14 = v_baltype_id
  where element_type_id = v_eletype_id
  and business_group_id is null
  and legislation_code = 'US';

Line: 282

  update pay_element_types_f
  set ELEMENT_INFORMATION15 = v_baltype_id
  where element_type_id = v_eletype_id
  and business_group_id is null
  and legislation_code = 'US';

Line: 291

  update pay_element_types_f
  set ELEMENT_INFORMATION16 = v_baltype_id
  where element_type_id = v_eletype_id
  and business_group_id is null
  and legislation_code = 'US';

Line: 300

  update pay_element_types_f
  set ELEMENT_INFORMATION17 = v_baltype_id
  where element_type_id = v_eletype_id
  and business_group_id is null
  and legislation_code = 'US';

Line: 309

  update pay_element_types_f
  set ELEMENT_INFORMATION18 = v_baltype_id
  where element_type_id = v_eletype_id
  and business_group_id is null
  and legislation_code = 'US';

Line: 318

  update pay_element_types_f
  set ELEMENT_INFORMATION19 = v_baltype_id
  where element_type_id = v_eletype_id
  and business_group_id is null
  and legislation_code = 'US';

Line: 327

  update pay_element_types_f
  set ELEMENT_INFORMATION20 = v_baltype_id
  where element_type_id = v_eletype_id
  and business_group_id is null
  and legislation_code = 'US';

Line: 1029

  SELECT EVENT_GROUP_ID
  INTO   l_entry_change_evnt_grp_id
  FROM   pay_event_groups
  WHERE  event_group_name = 'Entry Changes'
  AND    business_group_id is NULL
  AND    legislation_Code is NULL ;

Line: 1036

  SELECT EVENT_GROUP_ID
  INTO   l_reg_ear_evnt_grp_id
  FROM   pay_event_groups
  WHERE  event_group_name ='Regular Earnings'
  AND    legislation_Code = 'US';