APPS.PAY_GB_RETRO_UPGRADE dependencies on PAY_ELEMENT_SPAN_USAGES

Line 115: insert into pay_element_span_usages

111: fnd_file.put_line(fnd_file.log,'p_time_span_id ='|| p_time_span_id);
112: fnd_file.put_line(fnd_file.log,'p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
113: fnd_file.put_line(fnd_file.log,'p_retro_element_type_id ='|| p_retro_element_type_id);
114:
115: insert into pay_element_span_usages
116: (element_span_usage_id, business_group_id, time_span_id,
117: retro_component_usage_id, retro_element_type_id,
118: creation_date, created_by, last_update_date, last_updated_by,
119: last_update_login, object_version_number)

Line 121: SELECT pay_element_span_usages_s.nextval,

117: retro_component_usage_id, retro_element_type_id,
118: creation_date, created_by, last_update_date, last_updated_by,
119: last_update_login, object_version_number)
120: --values
121: SELECT pay_element_span_usages_s.nextval,
122: p_business_group_id, p_time_span_id,
123: p_retro_comp_usage_id, p_retro_element_type_id,
124: sysdate, 2, sysdate, 2, 2, 1
125: FROM dual

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

122: p_business_group_id, p_time_span_id,
123: p_retro_comp_usage_id, p_retro_element_type_id,
124: sysdate, 2, sysdate, 2, 2, 1
125: FROM dual
126: WHERE not exists ( SELECT 1 FROM pay_element_span_usages pesu
127: WHERE pesu.business_group_id = p_business_group_id
128: AND pesu.legislation_code IS NULL
129: AND pesu.time_span_id = p_time_span_id
130: AND retro_component_usage_id = p_retro_comp_usage_id);