APPS.PAY_US_W2_INFO_PKG dependencies on DUAL

Line 783: 'A_PER_PREFIX' ) into l_w2_fields.emp_name from dual;

779:
780: select l_first_name||decode(l_middle_name,null,' ',
781: ' '||substr(l_middle_name,1,1)||' ') ||
782: hr_us_w2_rep.get_per_item(p_asg_action_id,
783: 'A_PER_PREFIX' ) into l_w2_fields.emp_name from dual;
784: exception when others then null;
785: end ;
786:
787: -- bug 7593457

Line 2052: from dual ;

2048:
2049: if (instr(TEMP_UTL,' ') > 0 and TEMP_UTL is not null) then
2050: select substrb(TEMP_UTL, 1, instr(TEMP_UTL,' ') - 1)
2051: into g_temp_dir
2052: from dual ;
2053: elsif (TEMP_UTL is not null) then
2054: g_temp_dir := TEMP_UTL;
2055: end if;
2056: