APPS.PER_CN_SHARED_INFO SQL Statements

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

Line: 9

  select meaning from fnd_lookup_values
  where lookup_type = p_type
  and enabled_flag = 'Y'
  and lookup_code = p_code
  and language = userenv('lang')
  order by lookup_code;

Line: 49

 SELECT '1'
 FROM PER_ALL_PEOPLE_F
 WHERE PERSON_ID = p_person_id
 AND p_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;

Line: 55

 SELECT NATIONAL_IDENTIFIER
 FROM PER_ALL_PEOPLE_F
 WHERE PERSON_ID = p_person_id
 AND p_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;

Line: 61

 SELECT PEI_INFORMATION1 A, PEI_INFORMATION2 B
 FROM PER_PEOPLE_EXTRA_INFO
 WHERE PERSON_ID = p_person_id
 AND INFORMATION_TYPE = 'PER_PASS_INFO_CN'
 AND PEI_INFORMATION_CATEGORY = 'PER_PASS_INFO_CN'
 ORDER BY A;

Line: 69

 SELECT PEI_INFORMATION2
 FROM PER_PEOPLE_EXTRA_INFO
 WHERE PERSON_ID = p_person_id
 AND INFORMATION_TYPE = 'PER_PASSPORT_INFO_CN'
 AND PEI_INFORMATION_CATEGORY = 'PER_PASSPORT_INFO_CN';

Line: 153

SELECT  POSE.organization_id_parent organization_id
   FROM   per_org_structure_elements POSE
         ,per_organization_structures POS
         ,per_org_structure_versions POSV
  WHERE   POSV.org_structure_version_id = POSE.org_structure_version_id
    AND   POS.primary_structure_flag='Y'
    AND   POS.organization_structure_id = POSV.organization_structure_id
    AND   POSE.organization_id_child      = p_organization_id
    AND   EXISTS (SELECT 1
                    FROM hr_organization_information info
                   WHERE info.org_information1		= 'HR_ORG'
                     AND info.org_information_context	= 'CLASS'
                     AND info.organization_id = POSE.organization_id_parent
                     AND info.org_information2		= 'Y');

Line: 186

   select ANALYSIS_CRITERIA_ID
   from PER_PERSON_ANALYSES
   where person_id = p_person_id
   and business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
   and p_date between date_from and nvl(date_to,to_date('31-12-4712','dd-mm-yyyy'))
   and ID_FLEX_NUM = (select ID_FLEX_NUM
                      from FND_ID_FLEX_STRUCTURES_VL
                      where ID_FLEX_CODE='PEA' and
                      ID_FLEX_STRUCTURE_CODE = 'PER_JOB_CLASS_INFO_CN'
                     )
   order by date_from desc;

Line: 199

   select per_cn_shared_info.get_lookup_meaning(segment1,'CN_CADRE_JOB_CLASS')  from PER_ANALYSIS_CRITERIA
   where ANALYSIS_CRITERIA_ID = p_anal_cri_id
   and enabled_flag = 'Y';

Line: 229

   select ANALYSIS_CRITERIA_ID
   from PER_PERSON_ANALYSES
   where person_id = p_person_id
   and business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
   and p_date between date_from and nvl(date_to,to_date('31-12-4712','dd-mm-yyyy'))
   and ID_FLEX_NUM = (select ID_FLEX_NUM
                      from FND_ID_FLEX_STRUCTURES_VL
                      where ID_FLEX_CODE='PEA' and
                      ID_FLEX_STRUCTURE_CODE = 'PER_TECH_PROF_POST_CN'
                     )
   order by date_from desc;

Line: 242

   select per_cn_shared_info.get_lookup_meaning(segment1,'CN_TECH_TITLE')  from PER_ANALYSIS_CRITERIA
   where ANALYSIS_CRITERIA_ID = p_anal_cri_id
   and enabled_flag = 'Y';