APPS.HR_ES_UTILITY dependencies on DUAL

Line 152: FROM dual;

148: ||DECODE(p_per_information1, NULL,'',' ' || p_per_information1)
149: ||DECODE(p_first_name,NULL, '', ', ' || p_first_name)
150: )), 1, 240)
151: INTO l_full_name
152: FROM dual;
153: RETURN(l_full_name);
154: --
155: END per_es_full_name;
156: --------------------------------------------------------------------------------

Line 361: FROM sys.dual

357: --
358: BEGIN
359: SELECT 'Y'
360: INTO l_status
361: FROM sys.dual
362: WHERE exists(SELECT '1'
363: FROM per_people_f pp
364: WHERE (p_person_id IS NULL OR p_person_id <> pp.person_id)
365: AND p_identifier_value = pp.per_information3

Line 705: FROM sys.dual

701: BEGIN
702: BEGIN
703: SELECT 'Y'
704: INTO l_status
705: FROM sys.dual
706: WHERE exists(SELECT '1'
707: FROM per_shared_types pp
708: WHERE lookup_type = 'LEAV_REAS'
709: AND system_type_cd = p_leaving_reason