APPS.HR_REVTERMINATION_SS SQL Statements

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

Line: 15

select pps.SYSTEM_PERSON_TYPE
FROM
PER_PERSON_TYPES pps,
PER_ALL_PEOPLE_F ppf
where ppf.person_id = l_person_id
AND ppf.person_type_id = pps.person_type_id
AND ppf.effective_start_date = (select max(effective_start_date) from PER_ALL_PEOPLE_F papf1 where papf1.person_id = ppf.person_id);

Line: 24

select pps.SYSTEM_PERSON_TYPE
from PER_PERSON_TYPES pps
where pps.person_type_id = l_person_type_id;

Line: 153

select pps.person_type_id
FROM
PER_PERSON_TYPES pps,
PER_PERSON_TYPE_USAGES_F pptf
where pptf.person_id = l_person_id
AND pptf.person_type_id = pps.person_type_id
AND pps.SYSTEM_PERSON_TYPE = 'EX_EMP';

Line: 789

select pps.person_type_id
FROM
PER_PERSON_TYPES pps,
PER_PERSON_TYPE_USAGES_F pptf
where pptf.person_id = l_person_id
AND pptf.person_type_id = pps.person_type_id
AND pps.SYSTEM_PERSON_TYPE = 'EX_CWK';

Line: 1353

  ||             : and call the APIs in update mode
  ||=======================================================================
  */
  PROCEDURE process_api (
    p_validate            IN BOOLEAN DEFAULT FALSE,
    p_transaction_step_id IN NUMBER DEFAULT NULL,
    p_effective_date      IN VARCHAR2 DEFAULT NULL
  )
  IS

    -- For SAVE_FOR_LATER


    lv_rehire_recommendation        per_all_people_f.rehire_recommendation%TYPE;