The following lines contain the word 'select', 'insert', 'update' or 'delete':
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.
--
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
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';
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';
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);
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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 ;
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';