APPS.PER_JBR_BUS SQL Statements

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

Line: 59

   select 'x'
   from   per_jobs_v pj
   where  pj.job_id = p_job_id
   and    pj.business_group_id + 0 = p_business_group_id;

Line: 65

   select 'x'
   from   per_job_requirements pjr
   where (p_job_requirement_id <> pjr.job_requirement_id or
          p_job_requirement_id is NULL)
   and    p_job_id = pjr.job_id
   and    p_analysis_criteria_id = pjr.analysis_criteria_id;

Line: 168

     select 'x'
     from   hr_positions_f pos
     where  pos.position_id = p_position_id
     and    pos.business_group_id + 0 = p_business_group_id;

Line: 174

    select 'x'
    from   per_job_requirements pjr
    where  (p_job_requirement_id <> pjr.job_requirement_id or
            p_job_requirement_id is NULL)
    and    p_position_id = pjr.position_id
    and    p_analysis_criteria_id = pjr.analysis_criteria_id;

Line: 261

    select 'x'
    from   per_analysis_criteria pac
    where  pac.analysis_criteria_id = p_analysis_criteria_id;

Line: 408

    select 'x'
    from   hr_lookups hl
    where  hl.lookup_type = 'YES_NO'
    and    hl.lookup_code = p_essential;

Line: 587

Procedure insert_validate(p_rec in per_jbr_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 615

End insert_validate;

Line: 620

Procedure update_validate(p_rec in per_jbr_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 658

End update_validate;

Line: 663

Procedure delete_validate(p_rec in per_jbr_shd.g_rec_type) is
--
l_proc  varchar2(72) := g_package||'delete_validate';

Line: 673

End delete_validate;