APPS.PAYPLNK dependencies on DUAL

Line 1630: from sys.dual

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

Line 2266: from sys.dual

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

Line 3184: from dual

3180: fetch csr_asg_lines into g_line_record;
3181: begin
3182: select null
3183: into l_dummy
3184: from dual
3185: where exists(select null
3186: from pay_element_types_f ET,
3187: ben_benefit_classifications BCL
3188: where ET.element_type_id = g_line_record.element_type_id

Line 4988: from sys.dual;

4984: l_time_out := TRUE;
4985: select to_number(((to_char(sysdate, 'J') - 1 ) * 86400) +
4986: to_char(sysdate, 'SSSSS'))
4987: into l_stime
4988: from sys.dual;
4989: end if;
4990: --
4991: loop
4992: --

Line 5086: from sys.dual;

5082: --
5083: select to_number(((to_char(sysdate, 'J') - 1 ) * 86400) +
5084: to_char(sysdate, 'SSSSS'))
5085: into l_etime
5086: from sys.dual;
5087: --
5088: if ( (l_etime - l_stime) >= g_lock_max_wait) then
5089: raise;
5090: end if;

Line 5187: from sys.dual;

5183: l_time_out := TRUE;
5184: select to_number(((to_char(sysdate, 'J') - 1 ) * 86400) +
5185: to_char(sysdate, 'SSSSS'))
5186: into l_stime
5187: from sys.dual;
5188: end if;
5189: --
5190: loop
5191: --

Line 5279: from sys.dual;

5275: --
5276: select to_number(((to_char(sysdate, 'J') - 1 ) * 86400) +
5277: to_char(sysdate, 'SSSSS'))
5278: into l_etime
5279: from sys.dual;
5280: --
5281: if ( (l_etime - l_stime) >= g_lock_max_wait) then
5282: raise;
5283: end if;