APPS.PAY_GB_RETRO_UPGRADE dependencies on DUAL

Line 68: from dual;

64: fnd_file.put_line(fnd_file.log,'Entering ' || gv_package_name || lv_procedure_name);
65:
66: select pay_retro_component_usages_s.nextval
67: into ln_retro_component_usage_id
68: from dual;
69:
70: insert into pay_retro_component_usages
71: (retro_component_usage_id, retro_component_id, creator_id, creator_type,
72: default_component, reprocess_type, business_group_id, legislation_code,

Line 78: FROM dual

74: last_update_login, object_version_number)
75: SELECT ln_retro_component_usage_id, p_retro_component_id, p_creator_id,
76: 'ET', 'Y', 'R', p_business_group_id, p_legislation_code,
77: sysdate, 2, sysdate, 2, 2, 1
78: FROM dual
79: WHERE NOT EXISTS ( SELECT 1 FROM pay_retro_component_usages
80: WHERE retro_component_id = p_retro_component_id
81: AND creator_id = p_creator_id
82: AND creator_type = 'ET');

Line 125: FROM dual

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