APPS.HR_PSF_DEL dependencies on DUAL

Line 235: from sys.dual

231: l_exists := NULL;
232: begin
233: select '1'
234: into l_exists
235: from sys.dual
236: where exists(SELECT NULL
237: from PER_BUDGET_ELEMENTS BE
238: where BE.POSITION_ID = p_position_id);
239: exception when no_data_found then

Line 253: from sys.dual

249: end if;
250: begin
251: select '1'
252: into l_exists
253: from sys.dual
254: where exists(SELECT NULL
255: from PER_VACANCIES VAC
256: where VAC.POSITION_ID = p_position_id);
257: exception when no_data_found then

Line 294: from sys.dual

290: --if l_pos_structure_element_id is null then -- condition removed (Bug 9146790)
291: begin
292: select '1'
293: into l_exists
294: from sys.dual
295: where exists(SELECT NULL
296: FROM PER_POS_STRUCTURE_ELEMENTS PSE
297: WHERE PSE.PARENT_POSITION_ID = p_position_id
298: OR PSE.SUBORDINATE_POSITION_ID = p_position_id) ;

Line 317: from sys.dual

313: end if;
314: begin
315: select '1'
316: into l_exists
317: from sys.dual
318: where exists(SELECT NULL
319: FROM PER_VALID_GRADES VG1
320: WHERE business_group_id + 0 = p_business_group_id
321: AND VG1.POSITION_ID = p_position_id);

Line 339: from sys.dual

335: end if;
336: begin
337: select '1'
338: into l_exists
339: from sys.dual
340: where exists(select null
341: from per_job_requirements jre1
342: where jre1.position_id = p_position_id);
343: exception when no_data_found then

Line 357: from sys.dual

353: end if;
354: begin
355: select '1'
356: into l_exists
357: from sys.dual
358: where exists(select null
359: from per_job_evaluations jev1
360: where jev1.position_id = p_position_id);
361: exception when no_data_found then

Line 376: from sys.dual

372: end if;
373: begin
374: select '1'
375: into l_exists
376: from sys.dual
377: where exists(select null
378: from hr_all_positions_f
379: where successor_position_id = p_position_id);
380: exception when no_data_found then

Line 397: from sys.dual

393:
394: begin
395: select '1'
396: into l_exists
397: from sys.dual
398: where exists(select null
399: from hr_All_positions_f
400: where relief_position_id = p_position_id);
401: exception when no_data_found then

Line 418: from sys.dual

414:
415: begin
416: select '1'
417: into l_exists
418: from sys.dual
419: where exists(select null
420: from per_mm_positions
421: where new_position_id = p_position_id);
422: exception when no_data_found then

Line 442: ||' from sys.dual '

438: --
439: -- if p_po_ins = 'Y' then
440: begin
441: l_sql_text := 'select null '
442: ||' from sys.dual '
443: ||' where exists( select null '
444: ||' from po_system_parameters '
445: ||' where security_position_structure_id = '
446: ||to_char(p_position_id)