[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
INTO l_status
FROM sys.dual
WHERE exists(SELECT /*+index(pp)*/'1'
FROM per_all_people_f pp
WHERE (p_person_id IS NULL
OR p_person_id <> pp.person_id)
AND translate(l_valid, '1-', '1') = translate(pp.per_information2, '1-', '1')
AND pp.business_group_id +0 = p_business_group_id);
SELECT 'Y'
INTO l_status
FROM sys.dual
WHERE exists(SELECT /*+INDEX(pp)*/'1'
FROM per_all_people_f pp
WHERE (p_person_id IS NULL
OR p_person_id <> pp.person_id)
AND translate(l_valid, '1-', '1') = translate(pp.per_information3, '1-', '1')
AND pp.business_group_id +0 = p_business_group_id);
SELECT 'Y'
INTO l_status
FROM sys.dual
WHERE exists(SELECT '1'
FROM per_all_people_f pp
WHERE (p_person_id IS NULL
OR p_person_id <> pp.person_id)
AND p_ms_id = pp.per_information6
AND pp.business_group_id = p_business_group_id);
SELECT 'Y'
INTO l_status
FROM sys.dual
WHERE exists(SELECT '1'
FROM per_all_people_f pp
WHERE (p_person_id IS NULL
OR p_person_id <> pp.person_id)
AND p_fga_id = pp.per_information5
AND pp.business_group_id = p_business_group_id);
SELECT 'Y'
INTO l_status
FROM sys.dual
WHERE exists(SELECT /*+index(pdf per_disabilities_f_pk)*/'1'
FROM per_disabilities_f pdf
WHERE (p_disab_id IS NULL
OR p_disab_id <> pdf.disability_id)
AND l_valid = pdf.registration_id
);