APPS.PAY_US_RETRO_UPGRADE dependencies on PAY_ELEMENT_SPAN_USAGES

Line 119: insert into pay_element_span_usages

115: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
116: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
117: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
118:
119: insert into pay_element_span_usages
120: (element_span_usage_id, business_group_id, time_span_id,
121: retro_component_usage_id, retro_element_type_id,
122: creation_date, created_by, last_update_date, last_updated_by,
123: last_update_login, object_version_number)

Line 124: select pay_element_span_usages_s.nextval, p_business_group_id, p_time_span_id,

120: (element_span_usage_id, business_group_id, time_span_id,
121: retro_component_usage_id, retro_element_type_id,
122: creation_date, created_by, last_update_date, last_updated_by,
123: last_update_login, object_version_number)
124: select pay_element_span_usages_s.nextval, p_business_group_id, p_time_span_id,
125: p_retro_comp_usage_id, p_retro_element_type_id,
126: sysdate, 2, sysdate, 2, 2, 1
127: from dual
128: WHERE not exists ( SELECT 1 FROM pay_element_span_usages pesu

Line 128: WHERE not exists ( SELECT 1 FROM pay_element_span_usages pesu

124: select pay_element_span_usages_s.nextval, p_business_group_id, p_time_span_id,
125: p_retro_comp_usage_id, p_retro_element_type_id,
126: sysdate, 2, sysdate, 2, 2, 1
127: from dual
128: WHERE not exists ( SELECT 1 FROM pay_element_span_usages pesu
129: WHERE pesu.business_group_id = p_business_group_id
130: AND pesu.legislation_code IS NULL
131: AND pesu.time_span_id = p_time_span_id
132: AND retro_component_usage_id = p_retro_comp_usage_id); /* 7138282 */