DBA Data[Home] [Help]

APPS.PER_CN_EXTRA_PER_INFO_LEG_HOOK SQL Statements

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

Line: 40

     SELECT information_type
     FROM   per_people_extra_info
     WHERE  person_extra_info_id = p_person_extra_info_id;
Line: 45

     SELECT detail.person_extra_info_id
     FROM   per_people_extra_info detail
     WHERE  detail.information_type = 'PER_ABROAD_DETAIL_INFO_CN'
     AND    p_person_extra_info_id=detail.pei_information1;
Line: 51

     SELECT detail.person_extra_info_id
     FROM   per_people_extra_info detail,per_people_extra_info visa
     WHERE  detail.information_type = 'PER_ABROAD_DETAIL_INFO_CN'
     AND    detail.pei_information5 = visa.pei_information1
     AND    visa.person_extra_info_id = p_person_extra_info_id;
Line: 58

     SELECT pei_information1
     FROM   per_people_extra_info
     WHERE  information_type = 'PER_ABROAD_MASTER_INFO_CN'
     AND    person_extra_info_id =  p_person_extra_info_id;
Line: 64

     SELECT pei_information1
     FROM   per_people_extra_info
     WHERE  information_type = 'PER_VISA_INFO_CN'
     AND    person_extra_info_id =  p_person_extra_info_id;