APPS.HR_RO_CONTRACT_VAL SQL Statements

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

Line: 13

        select 'x'
        from   hr_lookups
        where  lookup_type    = 'RO_LEGAL_SUSPENDED_REASON'
        and    enabled_flag   = 'Y'
        and    lookup_code    = p_ctr_information1;

Line: 20

        select 'x'
        from   hr_lookups
        where  lookup_type    = 'RO_LEGAL_TERMINATED_REASON'
        and    enabled_flag   = 'Y'
        and    lookup_code    = p_ctr_information1;

Line: 27

        select 'x'
        from   hr_lookups
        where  lookup_type    = 'RO_LEGAL_REACTIVATED_REASON'
        and    enabled_flag   = 'Y'
        and    lookup_code    = p_ctr_information1;

Line: 34

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 SYSDATE between ppf.effective_start_date and ppf.effective_end_date;

Line: 42

select 'x'
  from fnd_lookup_values flv
  where flv.lookup_type='CONTRACT_STATUS'
   and  flv.language = userenv('LANG')
   and  (flv.security_group_id = p_security_id OR flv.tag is null OR flv.tag like '%+RO%')
   and flv.lookup_code = p_status;

Line: 50

select 'x'
  from fnd_lookup_values flv
  where flv.lookup_type='CONTRACT_TYPE'
   and  flv.language = userenv('LANG')
   and  (flv.security_group_id = p_security_id OR  flv.tag is null OR flv.tag like '%+RO%')
   and flv.lookup_code = p_type;

Line: 158

   select 'x'
   from   per_contracts_f
   where  person_id     = p_person_id
   and    p_effective_date  between effective_start_date and effective_end_date;

Line: 207

PROCEDURE UPDATE_RO_CONTRACT(p_person_id				  NUMBER
							,p_type                       VARCHAR2
                            ,p_status                     VARCHAR2
                            ,p_ctr_information1           VARCHAR2
                            )

IS

l_proc varchar2(60);

Line: 218

l_proc:= g_package||'UPDATE_RO_CONTRACT';

Line: 233

END UPDATE_RO_CONTRACT;