APPS.HR_SA_GET_PERSON_DETAILS SQL Statements

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

Line: 11

     select a.meaning
     from   per_all_people_f       PEOPLE
            ,hr_lookups             a
            ,per_all_assignments_f  ASSIGN
            ,per_shared_types       SHTYPE
    where   l_effective_date between ASSIGN.effective_start_date
                             and ASSIGN.effective_end_date
    and     l_effective_date BETWEEN PEOPLE.effective_start_date
                             and PEOPLE.effective_end_date
    and     ASSIGN.assignment_id = l_assignment_id
    and     PEOPLE.person_id     = ASSIGN.person_id
    and     SHTYPE.LOOKUP_TYPE     (+)= 'NATIONALITY'
    and     PEOPLE.NATIONALITY     (+)= SHTYPE.SYSTEM_TYPE_CD
    and     a.lookup_code        (+)= SHTYPE.INFORMATION5
    and     a.lookup_type        (+)= 'NATIONALITY_GROUP'
    and     a.application_id  (+)= 800;

Line: 51

     select a.meaning
     from   per_all_people_f       PEOPLE
            ,hr_lookups             a
            ,per_shared_types       SHTYPE
    where   PEOPLE.person_id     = l_person_id
    and     l_effective_date BETWEEN PEOPLE.effective_start_date
                             AND PEOPLE.effective_end_date
    and     SHTYPE.LOOKUP_TYPE     (+)= 'NATIONALITY'
    and     PEOPLE.NATIONALITY     (+)= SHTYPE.SYSTEM_TYPE_CD
    and     a.lookup_code        (+)= SHTYPE.INFORMATION5
    and     a.lookup_type        (+)= 'NATIONALITY_GROUP'
    and     a.application_id  (+)= 800;