APPS.PER_GB_DISABILITY SQL Statements

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

Line: 12

select distinct security_group_id
from  per_all_people_f ppf
     ,per_business_groups pbg
where ppf.person_id = p_person_id
and ppf.business_group_id= pbg.business_group_id
and p_effective_date between
    ppf.effective_start_date and ppf.effective_end_date;

Line: 22

select flv.last_updated_by upd
  from fnd_lookup_values flv
  where flv.lookup_type='DISABILITY_CATEGORY'
   and  flv.language = userenv('LANG')
   and  flv.security_group_id = p_security_id
   and flv.lookup_code = p_category;

Line: 30

select flv.last_updated_by upd
  from fnd_lookup_values flv
  where flv.lookup_type='DISABILITY_CATEGORY'
   and  flv.language = userenv('LANG')
   and  flv.security_group_id =p_security_id
   and flv.lookup_code = p_category;

Line: 69

 PROCEDURE VALIDATE_UPDATE_DISABILITY(p_category  in  varchar2,
				      p_disability_id number,
				      p_effective_date date)
 AS


cursor csr_get_securityid
is
select distinct security_group_id
from  per_disabilities_f pdf
     ,per_all_people_f  ppf
     ,per_business_groups pbg
where ppf.person_id = pdf.person_id
and   ppf.business_group_id= pbg.business_group_id
and   pdf.disability_id = p_disability_id
and   p_effective_date between
      ppf.effective_start_date and ppf.effective_end_date;

Line: 89

select flv.last_updated_by upd
  from fnd_lookup_values flv
  where flv.lookup_type='DISABILITY_CATEGORY'
   and  flv.language = userenv('LANG')
   and  flv.security_group_id =p_security_id
   and flv.lookup_code = p_category;

Line: 98

select flv.last_updated_by upd
  from fnd_lookup_values flv
  where flv.lookup_type='DISABILITY_CATEGORY'
   and  flv.language = userenv('LANG')
   and  flv.security_group_id =p_security_id
   and flv.lookup_code = p_category;

Line: 134

 END VALIDATE_UPDATE_DISABILITY;