APPS.HR_PERSON_NAME dependencies on DUAL

Line 777: l_proc_call := l_proc_call||':p_per_information25,:p_per_information26,:p_per_information27,:p_per_information28,:p_per_information29,:p_per_information30),1,240)) FROM sys.dual ';

773: l_proc_call := l_proc_call||':p_per_information11,:p_per_information12,:p_per_information13,:p_per_information14,:p_per_information15,:p_per_information16,:p_per_information17,';
774:
775: l_proc_call := l_proc_call||':p_per_information18,:p_per_information19,:p_per_information20,:p_per_information21,:p_per_information22,:p_per_information23,:p_per_information24,';
776:
777: l_proc_call := l_proc_call||':p_per_information25,:p_per_information26,:p_per_information27,:p_per_information28,:p_per_information29,:p_per_information30),1,240)) FROM sys.dual ';
778:
779: EXECUTE IMMEDIATE l_proc_call
780: INTO l_formatted_name
781: USING p_name_column_rec.first_name

Line 1265: FROM sys.dual

1261: l_ll_check := lower(l_first_char)||lower(l_second_char)||'%';
1262:
1263: SELECT 'Y'
1264: INTO l_status
1265: FROM sys.dual
1266: WHERE EXISTS (SELECT /*+ no_expand */ 'Duplicate Person Exists'
1267: FROM per_all_people_f pp
1268: WHERE /* Perform case insensitive check on last name */
1269: /* trying to use the index on last name */