APPS.PER_PSV_BUS dependencies on DUAL

Line 315: from dual

311: -- Test for overlapping rows
312: --
313: select null
314: into l_dummy
315: from dual
316: where exists
317: (select 1
318: from per_pos_structure_versions osv
319: where osv.date_from <= nvl(p_Date_To, hr_api.g_eot)

Line 392: select 'N' from dual

388: (p_position_structure_id IN number
389: ) IS
390: l_proc VARCHAR2(72) := g_package||'chk_position_structure_id';
391: cursor csr_pos_str IS
392: select 'N' from dual
393: where not exists (select 'Y' from per_position_structures where position_structure_id = p_position_structure_id);
394: begin
395: --
396: hr_utility.set_location('Entering:'|| l_proc, 10);