APPS.HR_JOB_POS SQL Statements

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

Line: 51

PROCEDURE hr_jp_predelete(p_organization_id   INTEGER
                         ,p_business_group_id INTEGER) is
/*
  NAME
    hr_jp_predelete
  DESCRIPTION
    Battery of tests to see if an organization has jobs and positions
    and therefore may not be deleted.
  PARAMETERS
    p_organization_id  : Organization Id of Organization to be deleted.
    p_business_group_id   : Business Group id of Organization to be deleted.
*/
--
-- Storage Variable.
--
l_test_func varchar2(60);

Line: 73

    hr_utility.set_location('hr_job_pos.hr_jp_predelete',1);

Line: 74

    select '1'
    into l_test_func
    from sys.dual
    where exists ( select 1
    from PER_JOBS_V x
    where x.business_group_id = p_business_group_id);

Line: 96

    hr_utility.set_location('hr_job_pos.hr_jp_predelete',2);

Line: 97

    select '1'
    into l_test_func
    from sys.dual
    where exists ( select 1
    from HR_ALL_POSITIONS_F x
    where x.organization_id = p_organization_id);

Line: 113

end hr_jp_predelete;

Line: 125

    If so it may not be updated to a business group.
  PARAMETERS
    p_organization_id  : Organization Id of Business group to be created.
*/
--
-- Local Storage variable.
l_test_func varchar2(60);

Line: 138

select '1'
into l_test_func
from sys.dual
where exists ( select 1
from HR_ALL_POSITIONS_F x
where x.ORGANIZATION_ID = p_organization_id);