The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_select_string VARCHAR2(4000):=NULL;
SELECT organization_id organization_id
FROM hr_fr_establishments_v
WHERE company_org_id = to_char(p_company_id)
OR organization_id = p_company_id;
l_select_string := '(select '||p_establishment_id||' establishment_id from dual) v';
/* Bug 2217457 - Changed to use views instead of union select from dual */
l_select_string := '(SELECT organization_id establishment_id FROM hr_fr_establishments_v WHERE company_org_id = ';
l_select_string := l_select_string || to_char(p_company_id) || ' OR organization_id = ';
l_select_string := l_select_string || to_char(p_company_id) || ') v ';
l_prmrec(5).value := l_select_string;
PROCEDURE delete_gsp(errbuf OUT NOCOPY VARCHAR2
,retcode OUT NOCOPY NUMBER
,p_process_run_id IN NUMBER) IS
--
BEGIN
--
hrsumrep.delete_process_data(p_process_run_id);
END delete_gsp;