APPS.GHR_EXEMP_PURGE dependencies on DUAL

Line 28: FROM DUAL;

24: CURSOR get_months_years(p_eff_date in date)
25: IS
26: SELECT trunc(months_between(sysdate,p_eff_date)/12) years,
27: trunc(months_between(sysdate,p_eff_date)) - (12 * trunc(months_between(sysdate,p_eff_date)/12)) months
28: FROM DUAL;
29:
30: CURSOR c_get_dir
31: IS
32: SELECT value

Line 363: FROM sys.dual

359: BEGIN
360:
361: SELECT 'Y'
362: INTO l_delete_permitted
363: FROM sys.dual
364: WHERE not exists (
365: SELECT null
366: FROM PER_CONTACT_RELATIONSHIPS r
367: WHERE r.person_id = p_person_id

Line 381: FROM sys.dual

377: BEGIN
378:
379: SELECT 'Y'
380: INTO l_delete_permitted
381: FROM sys.dual
382: WHERE 1 >= (
383: SELECT count(*)
384: FROM per_assignments_f a
385: WHERE a.person_id = P_PERSON_ID

Line 400: FROM sys.dual

396: BEGIN
397:
398: SELECT 'Y'
399: INTO l_delete_permitted
400: FROM sys.dual
401: WHERE not exists (
402: SELECT null
403: FROM PER_ASSIGNMENTS_F a
404: WHERE a.recruiter_id = p_person_id

Line 419: from sys.dual

415: begin
416: --
417: select 'Y'
418: into l_delete_permitted
419: from sys.dual
420: where not exists (
421: select null
422: from per_secondary_ass_statuses s
423: where exists (