DBA Data[Home] [Help]

APPS.GHR_VALIDATE_PERWSEPI dependencies on PER_PEOPLE_F

Line 17: FROM per_people_f ppf, per_person_types pty

13:
14: -- This cursor gets the Person Type ID for Employee
15: CURSOR cur_chk_pst(p_business_group_id IN NUMBER,p_person_id IN NUMBER, p_effective_date IN DATE) IS
16: SELECT ppf.person_id
17: FROM per_people_f ppf, per_person_types pty
18: WHERE ppf.person_id = p_person_id
19: AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
20: AND ppf.person_type_id = pty.person_type_id
21: AND pty.system_person_type = 'EMP'