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)
502: AND l_valid = pdf.registration_id
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)
502: AND l_valid = pdf.registration_id
503: );