APPS.HR_MX_EXTRA_ASG_RULES dependencies on DUAL

Line 173: FROM DUAL;

169: SELECT decode(p_scl_segment1, hr_api.g_varchar2, l_scl_gre, p_scl_segment1),
170: decode(p_location_id, hr_api.g_number, l_location_old, p_location_id)
171: INTO l_segment1,
172: l_location_id
173: FROM DUAL;
174:
175: IF g_debug THEN
176: hr_utility.set_location(l_proc, 35);
177: END IF;

Line 357: FROM DUAL;

353: -- defaulted. (Bug 3777663)
354: --------------------------------------------------------------------------
355: SELECT decode(p_segment1, hr_api.g_varchar2, l_scl_gre, p_segment1)
356: INTO l_segment1
357: FROM DUAL;
358:
359: IF g_debug THEN
360: hr_utility.set_location(l_proc, 35);
361: END IF;