APPS.HR_KW_VALIDATE_PKG dependencies on PER_PERSON_TYPES

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

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

Line 28: FROM per_person_types ppt

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

Line 33: FROM per_person_types ppt

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

Line 146: FROM per_person_types ppt

142: l_person_type_id NUMBER;
143: l_person_type VARCHAR2(20);
144: CURSOR chk_person_type IS
145: SELECT 'Y'
146: FROM per_person_types ppt
147: WHERE ppt.system_person_type IN ('CWK')
148: AND ppt.person_type_id = p_person_type_id;
149: BEGIN
150: OPEN csr_person_type_id;