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 686: from dual;

682: message_name fnd_new_messages.message_name%TYPE;
683:
684: cursor csr_error_message is
685: select fnd_message.get_string(message_cat,message_name)
686: from dual;
687:
688: BEGIN
689: lookup_type_val := 'PL_TYPE_OF_SERVICE';
690: lookup_descr_val1 := '01';

Line 1212: FROM sys.dual

1208: l_prof_val varchar2(30);
1209: begin
1210: SELECT 'Y'
1211: INTO l_status
1212: FROM sys.dual
1213: WHERE exists(SELECT '1'
1214: FROM per_all_people_f pp
1215: WHERE (p_person_id IS NULL
1216: OR p_person_id <> pp.person_id)