APPS.PA_ROLE_JOB_BG_UTILS SQL Statements

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

Line: 29

select 'Y'
from   pa_role_job_bgs
where  project_role_id = p_project_role_id
and    nvl(business_group_id, -99) = nvl(p_business_group_id, -99)
and    role_job_bg_id <> nvl(p_role_job_bg_id, -99);

Line: 82

   SELECT job_id
   into   l_job_id
   FROM   pa_role_job_bgs
   WHERE  project_role_id = p_project_role_id
   AND    nvl(business_group_id, -1) = l_bg_id;

Line: 116

   SELECT min_job_level
   into   l_min_job_level
   FROM   pa_role_job_bgs
   WHERE  project_role_id = p_project_role_id
   AND    nvl(business_group_id, -1) = l_bg_id;

Line: 150

   SELECT max_job_level
   into   l_max_job_level
   FROM   pa_role_job_bgs
   WHERE  project_role_id = p_project_role_id
   AND    nvl(business_group_id, -1) = l_bg_id;