APPS.HR_TCA_UTILITY SQL Statements

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

Line: 23

       SELECT ppf.PERSON_ID
	         ,typ.SYSTEM_PERSON_TYPE
       FROM  per_all_people_f ppf
            ,per_person_types typ
            ,per_person_type_usages_f ptu
       WHERE ppf.party_id           = p_party_id
       AND   l_effective_date between ppf.effective_start_date
                                  and ppf.effective_end_date
       AND   ppf.person_id          = ptu.person_id
       AND   typ.person_type_id     = ptu.person_type_id
       AND   l_effective_date between ptu.effective_start_date
                                  and ptu.effective_end_date
       ORDER BY DECODE(typ.system_person_type
                      ,'EMP'   ,1
                      ,'CWK'   ,2
                      ,'APL'   ,3
                      ,'EX_EMP',4
                      ,'EX_CWK',5
                      ,'EX_APL',6
                               ,7
                      ), ppf.person_id desc;

Line: 53

       SELECT ppf.PERSON_ID
       FROM  per_all_people_f ppf
       WHERE ppf.party_id           = p_party_id
       AND   l_effective_date between ppf.effective_start_date
                                  and ppf.effective_end_date
       AND   ppf.person_id <> p_person_id;