APPS.PAY_US_RETRO_UPGRADE dependencies on DUAL

Line 71: from dual;

67: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
68:
69: select pay_retro_component_usages_s.nextval
70: into ln_retro_component_usage_id
71: from dual;
72:
73: insert into pay_retro_component_usages
74: (retro_component_usage_id, retro_component_id, creator_id, creator_type,
75: default_component, reprocess_type, business_group_id, legislation_code,

Line 81: from dual

77: last_update_login, object_version_number)
78: select ln_retro_component_usage_id, p_retro_component_id, p_creator_id,
79: 'ET', 'Y', 'R', p_business_group_id, p_legislation_code,
80: sysdate, 2, sysdate, 2, 2, 1
81: from dual
82: WHERE NOT EXISTS ( SELECT 1 FROM pay_retro_component_usages
83: WHERE retro_component_id = p_retro_component_id
84: AND creator_id = p_creator_id
85: AND creator_type = 'ET'); /* 7138282 */

Line 127: from dual

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
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