DBA Data[Home] [Help]

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 192: per_person_types pty

188: DECLARE
189: CURSOR csr_get_loc_nat IS
190: SELECT org_information1
191: FROM hr_organization_information hoi,
192: per_person_types pty
193: WHERE pty.person_type_id = p_person_type_id
194: AND pty.business_group_id = hoi.organization_id
195: AND hoi.org_information_context = 'AE_BG_DETAILS';
196: rec_get_loc_nat csr_get_loc_nat%ROWTYPE;

Line 218: FROM per_person_types pty,

214: l_count NUMBER;
215:
216: CURSOR csr_fetch_bg_id IS
217: SELECT distinct pty.business_group_id
218: FROM per_person_types pty,
219: hr_organization_information hoi
220: WHERE pty.person_type_id = p_person_type_id
221: AND pty.business_group_id = hoi.organization_id;
222:

Line 311: FROM per_person_types ppt

307: l_person_type_id NUMBER;
308: l_person_type VARCHAR2(20);
309: CURSOR chk_person_type IS
310: SELECT 'Y'
311: FROM per_person_types ppt
312: WHERE ppt.system_person_type IN ('CWK')
313: AND ppt.person_type_id = p_person_type_id;
314: BEGIN
315: OPEN csr_person_type_id;