APPS.HR_PL_UTILITY dependencies on DUAL

Line 57: FROM dual;

53: ||DECODE(p_middle_names,NULL, '', ' ' || p_middle_names)
54: ||DECODE(p_title,NULL, '', ' ' || p_title)
55: )), 1, 240)
56: INTO l_full_name
57: FROM dual;
58: RETURN(l_full_name);
59: --
60: END per_pl_full_name;
61: --------------------------------------------------------------------------------

Line 115: FROM dual;

111: ||DECODE(p_middle_names,NULL, '', ' ' || p_middle_names)
112: ||DECODE(p_title,NULL, '', ' ' || p_title)
113: )), 1, 240)
114: INTO l_order_name
115: FROM dual;
116: RETURN(l_order_name);
117: --
118: END per_pl_order_name;
119:

Line 732: from dual;

728: message_name fnd_new_messages.message_name%TYPE;
729:
730: cursor csr_error_message is
731: select fnd_message.get_string(message_cat,message_name)
732: from dual;
733:
734: BEGIN
735: lookup_type_val := 'PL_TYPE_OF_SERVICE';
736: lookup_descr_val1 := '01';

Line 1255: FROM sys.dual

1251: l_prof_val varchar2(30);
1252: begin
1253: SELECT 'Y'
1254: INTO l_status
1255: FROM sys.dual
1256: WHERE exists(SELECT '1'
1257: FROM per_all_people_f pp
1258: WHERE (p_person_id IS NULL
1259: OR p_person_id <> pp.person_id)