APPS.PAYPLNK dependencies on DUAL

Line 1628: from sys.dual

1624: --
1625: begin
1626: select 'x'
1627: into l_transfer_recs
1628: from sys.dual
1629: where exists
1630: (select null
1631: from pay_batch_headers bah
1632: , pay_batch_lines bal

Line 2264: from sys.dual

2260: --
2261: begin
2262: select 'x'
2263: into l_exists
2264: from sys.dual
2265: where exists
2266: (select null
2267: from hr_lookups hlk
2268: where upper( hlk.lookup_type) = 'CONTROL_TYPE'

Line 3175: from dual

3171: fetch csr_asg_lines into g_line_record;
3172: begin
3173: select null
3174: into l_dummy
3175: from dual
3176: where exists(select null
3177: from pay_element_types_f ET,
3178: ben_benefit_classifications BCL
3179: where ET.element_type_id = g_line_record.element_type_id

Line 4956: from sys.dual;

4952: l_time_out := TRUE;
4953: select to_number(((to_char(sysdate, 'J') - 1 ) * 86400) +
4954: to_char(sysdate, 'SSSSS'))
4955: into l_stime
4956: from sys.dual;
4957: end if;
4958: --
4959: loop
4960: --

Line 5054: from sys.dual;

5050: --
5051: select to_number(((to_char(sysdate, 'J') - 1 ) * 86400) +
5052: to_char(sysdate, 'SSSSS'))
5053: into l_etime
5054: from sys.dual;
5055: --
5056: if ( (l_etime - l_stime) >= g_lock_max_wait) then
5057: raise;
5058: end if;

Line 5155: from sys.dual;

5151: l_time_out := TRUE;
5152: select to_number(((to_char(sysdate, 'J') - 1 ) * 86400) +
5153: to_char(sysdate, 'SSSSS'))
5154: into l_stime
5155: from sys.dual;
5156: end if;
5157: --
5158: loop
5159: --

Line 5247: from sys.dual;

5243: --
5244: select to_number(((to_char(sysdate, 'J') - 1 ) * 86400) +
5245: to_char(sysdate, 'SSSSS'))
5246: into l_etime
5247: from sys.dual;
5248: --
5249: if ( (l_etime - l_stime) >= g_lock_max_wait) then
5250: raise;
5251: end if;