APPS.PQH_PROCESS_TENURE_STATUS SQL Statements

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

Line: 45

    select
       tenure.person_id,
       'PQH_TENURE_STATUS' pei_information_category,
       tenure.pei_information1,
       fnd_date.canonical_to_date(tenure.pei_information2)  pei_information2,
       fnd_date.canonical_to_date(tenure.pei_information3)  pei_information3,
       fnd_date.canonical_to_date(tenure.pei_information4)  pei_information4,
       tenure.pei_information5,
       to_number(tenure.person_extra_info_id ) person_extra_info_id,
       to_number(tenure.object_version_number) object_version_number,
       hl.meaning Tenure_desc,
       tenure.pei_information6
    from (
      Select max(person_id) person_id ,
             max(pei_information1) pei_information1,
             max(person_extra_info_id) person_extra_info_id,
             max(object_version_number) object_version_number,
             max(pei_information2) pei_information2,
             max(pei_information3) pei_information3,
             max(pei_information4) pei_information4,
             max(pei_information5) pei_information5,
             max(pei_information6) pei_information6
      from (
          SELECT decode(a.name, 'P_PERSON_ID'            , a.varchar2_value, null) person_id,
                 decode(a.name, 'P_TENURE_STATUS'        , a.varchar2_value,null)  pei_information1,
                 decode(a.name, 'P_DATE_DETERMINE'       , a.varchar2_value,null)  pei_information2,
                 decode(a.name, 'P_PROJECTED_TENURE_DATE', a.varchar2_value ,null) pei_information3,
                 decode(a.name, 'P_ADJUSTED_DATE'        , a.varchar2_value ,null) pei_information4,
                 decode(a.name, 'P_REASON_ADJUSTED'      , a.varchar2_value ,null) pei_information5,
                 decode(a.name, 'P_PERSON_EXTRA_INFO_ID' , a.varchar2_value ,null) person_extra_info_id,
                 decode(a.name, 'P_OBJECT_VERSION_NUMBER', a.varchar2_value ,null) object_version_number,
                 decode(a.name, 'P_SUBJECT_TO_QUOTA'     , a.varchar2_value ,null) pei_information6
                FROM hr_api_transaction_steps s,
                     hr_api_transaction_values a
                WHERE s.transaction_step_id = a.transaction_step_id
                and s.transaction_step_id = p_transaction_step_id
                AND s.api_name = 'PQH_PROCESS_TENURE_STATUS.PROCESS_API'
                )
          )  tenure ,
             hr_lookups hl
      where  hl.lookup_type  = 'PQH_TENURE_STATUS'
      AND    hl.lookup_code  = tenure.pei_information1;

Line: 342

     HR_PERSON_EXTRA_INFO_API.update_person_extra_info (
	p_person_extra_info_id		=> l_person_extra_info_id,
	p_pei_information1		=> l_pei_information1 ,
	p_pei_information2		=> l_pei_information2 ,
	p_pei_information3		=> l_pei_information3 ,
	p_pei_information4		=> l_pei_information4 ,
	p_pei_information5		=> l_pei_information5 ,
	p_pei_information6		=> l_pei_information6 ,
	p_object_version_number		=> l_ovn  );