APPS.HRFRBSOC SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

l_select_string VARCHAR2(4000):=NULL;

Line: 22

 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;

Line: 30

   l_select_string := '(select '||p_establishment_id||' establishment_id from dual) v';

Line: 33

   /* 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 = ';

Line: 35

   l_select_string := l_select_string || to_char(p_company_id) || ' OR    organization_id = ';

Line: 36

   l_select_string := l_select_string || to_char(p_company_id) || ') v ';

Line: 62

l_prmrec(5).value := l_select_string;

Line: 88

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);

Line: 99

END delete_gsp;