APPS.HR_SA_VALIDATE_PKG dependencies on PER_PERSON_TYPES

Line 26: SELECT /*+ INDEX(ppt,PER_PERSON_TYPES_PK) */ 'Y'

22: ) IS
23: v_field varchar2(300) := NULL;
24: l_valid_date varchar2(10);
25: CURSOR c_type IS
26: SELECT /*+ INDEX(ppt,PER_PERSON_TYPES_PK) */ 'Y'
27: FROM per_person_types ppt
28: WHERE ppt.system_person_type IN ('CWK','EMP','APL')
29: AND ppt.person_type_Id = p_person_type_id;
30: CURSOR c_emp_type IS

Line 27: FROM per_person_types ppt

23: v_field varchar2(300) := NULL;
24: l_valid_date varchar2(10);
25: CURSOR c_type IS
26: SELECT /*+ INDEX(ppt,PER_PERSON_TYPES_PK) */ 'Y'
27: FROM per_person_types ppt
28: WHERE ppt.system_person_type IN ('CWK','EMP','APL')
29: AND ppt.person_type_Id = p_person_type_id;
30: CURSOR c_emp_type IS
31: SELECT 'Y'

Line 32: FROM per_person_types

28: WHERE ppt.system_person_type IN ('CWK','EMP','APL')
29: AND ppt.person_type_Id = p_person_type_id;
30: CURSOR c_emp_type IS
31: SELECT 'Y'
32: FROM per_person_types
33: WHERE system_person_type LIKE 'EMP%'
34: AND person_type_Id = p_person_type_id;
35: l_emp_type varchar2(10);
36: BEGIN