DBA Data[Home] [Help]

APPS.HR_APPLICANT_DATAUPD dependencies on PER_PERSON_TYPES

Line 87: ,per_person_types ppt

83: --
84: CURSOR csr_lock_ptu(cp_person_id number, cp_termination_date date) IS
85: SELECT null
86: FROM per_person_type_usages_f ptu
87: ,per_person_types ppt
88: WHERE person_id = cp_person_id
89: AND (effective_start_date > cp_termination_date
90: OR
91: cp_termination_date between effective_start_date