APPS.PAY_US_W2_INFO_PKG dependencies on DUAL

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

727:
728: select l_first_name||decode(l_middle_name,null,' ',
729: ' '||substr(l_middle_name,1,1)||' ') ||
730: hr_us_w2_rep.get_per_item(p_asg_action_id,
731: 'A_PER_PREFIX' ) into l_w2_fields.emp_name from dual;
732: exception when others then null;
733: end ;
734:
735: lr_employee_addr :=

Line 1940: from dual ;

1936:
1937: if (instr(TEMP_UTL,' ') > 0 and TEMP_UTL is not null) then
1938: select substrb(TEMP_UTL, 1, instr(TEMP_UTL,' ') - 1)
1939: into g_temp_dir
1940: from dual ;
1941: elsif (TEMP_UTL is not null) then
1942: g_temp_dir := TEMP_UTL;
1943: end if;
1944: