APPS.PAY_IP_RETRO_UPGRADE dependencies on PAY_ELEMENT_SPAN_USAGES

Line 104: insert into pay_element_span_usages

100: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
101: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
102: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
103:
104: insert into pay_element_span_usages
105: (element_span_usage_id, business_group_id, time_span_id,
106: retro_component_usage_id, retro_element_type_id,
107: creation_date, created_by, last_update_date, last_updated_by,
108: last_update_login, object_version_number)

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

105: (element_span_usage_id, business_group_id, time_span_id,
106: retro_component_usage_id, retro_element_type_id,
107: creation_date, created_by, last_update_date, last_updated_by,
108: last_update_login, object_version_number)
109: select pay_element_span_usages_s.nextval, p_business_group_id, p_time_span_id,
110: p_retro_comp_usage_id, p_retro_element_type_id,
111: sysdate, 2, sysdate, 2, 2, 1
112: from dual
113: WHERE not exists ( SELECT 1 FROM pay_element_span_usages pesu

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

109: select pay_element_span_usages_s.nextval, p_business_group_id, p_time_span_id,
110: p_retro_comp_usage_id, p_retro_element_type_id,
111: sysdate, 2, sysdate, 2, 2, 1
112: from dual
113: WHERE not exists ( SELECT 1 FROM pay_element_span_usages pesu
114: WHERE pesu.business_group_id = p_business_group_id
115: AND pesu.legislation_code IS NULL
116: AND pesu.time_span_id = p_time_span_id
117: AND retro_component_usage_id = p_retro_comp_usage_id);