APPS.HR_AE_VALIDATE_PKG dependencies on PER_PERSON_TYPES

Line 41: FROM per_person_types ppt

37: v_len_field varchar2(300);
38: l_valid_date varchar2(10);
39: CURSOR c_type IS
40: SELECT 'Y'
41: FROM per_person_types ppt
42: WHERE ppt.system_person_type IN ('EMP','APL')
43: AND ppt.person_type_Id = p_person_type_id;
44: CURSOR c_per_type IS
45: SELECT 'Y'

Line 46: FROM per_person_types ppt

42: WHERE ppt.system_person_type IN ('EMP','APL')
43: AND ppt.person_type_Id = p_person_type_id;
44: CURSOR c_per_type IS
45: SELECT 'Y'
46: FROM per_person_types ppt
47: WHERE ppt.system_person_type LIKE 'EMP%'
48: AND ppt.person_type_Id = p_person_type_id;
49: BEGIN
50:

Line 186: per_person_types pty

182: DECLARE
183: CURSOR csr_get_loc_nat IS
184: SELECT org_information1
185: FROM hr_organization_information hoi,
186: per_person_types pty
187: WHERE pty.person_type_id = p_person_type_id
188: AND pty.business_group_id = hoi.organization_id
189: AND hoi.org_information_context = 'AE_BG_DETAILS';
190: rec_get_loc_nat csr_get_loc_nat%ROWTYPE;

Line 212: FROM per_person_types pty,

208: l_count NUMBER;
209:
210: CURSOR csr_fetch_bg_id IS
211: SELECT distinct pty.business_group_id
212: FROM per_person_types pty,
213: hr_organization_information hoi
214: WHERE pty.person_type_id = p_person_type_id
215: AND pty.business_group_id = hoi.organization_id;
216:

Line 305: FROM per_person_types ppt

301: l_person_type_id NUMBER;
302: l_person_type VARCHAR2(20);
303: CURSOR chk_person_type IS
304: SELECT 'Y'
305: FROM per_person_types ppt
306: WHERE ppt.system_person_type IN ('CWK')
307: AND ppt.person_type_id = p_person_type_id;
308: BEGIN
309: OPEN csr_person_type_id;