APPS.PER_MX_VALIDATIONS dependencies on DUAL

Line 80: FROM sys.dual

76: --
77: BEGIN
78: SELECT 'Y'
79: INTO l_status
80: FROM sys.dual
81: WHERE exists(SELECT /*+index(pp)*/'1'
82: FROM per_all_people_f pp
83: WHERE (p_person_id IS NULL
84: OR p_person_id <> pp.person_id)

Line 190: FROM sys.dual

186: --
187: BEGIN
188: SELECT 'Y'
189: INTO l_status
190: FROM sys.dual
191: WHERE exists(SELECT /*+INDEX(pp)*/'1'
192: FROM per_all_people_f pp
193: WHERE (p_person_id IS NULL
194: OR p_person_id <> pp.person_id)

Line 292: FROM sys.dual

288: --
289: BEGIN
290: SELECT 'Y'
291: INTO l_status
292: FROM sys.dual
293: WHERE exists(SELECT '1'
294: FROM per_all_people_f pp
295: WHERE (p_person_id IS NULL
296: OR p_person_id <> pp.person_id)

Line 385: FROM sys.dual

381: --
382: BEGIN
383: SELECT 'Y'
384: INTO l_status
385: FROM sys.dual
386: WHERE exists(SELECT '1'
387: FROM per_all_people_f pp
388: WHERE (p_person_id IS NULL
389: OR p_person_id <> pp.person_id)

Line 497: FROM sys.dual

493: --
494: BEGIN
495: SELECT 'Y'
496: INTO l_status
497: FROM sys.dual
498: WHERE exists(SELECT /*+index(pdf per_disabilities_f_pk)*/'1'
499: FROM per_disabilities_f pdf
500: WHERE (p_disab_id IS NULL
501: OR p_disab_id <> pdf.disability_id)