APPS.HR_REVTERMINATION_SS dependencies on PER_PERSON_TYPES

Line 17: PER_PERSON_TYPES pps,

13:
14: cursor csr_person_type(l_person_id Number) is
15: select pps.SYSTEM_PERSON_TYPE
16: FROM
17: PER_PERSON_TYPES pps,
18: PER_ALL_PEOPLE_F ppf
19: where ppf.person_id = l_person_id
20: AND ppf.person_type_id = pps.person_type_id
21: AND ppf.effective_start_date = (select max(effective_start_date) from PER_ALL_PEOPLE_F papf1 where papf1.person_id = ppf.person_id);

Line 25: from PER_PERSON_TYPES pps

21: AND ppf.effective_start_date = (select max(effective_start_date) from PER_ALL_PEOPLE_F papf1 where papf1.person_id = ppf.person_id);
22:
23: cursor csr_get_person_type(l_person_type_id Number) is
24: select pps.SYSTEM_PERSON_TYPE
25: from PER_PERSON_TYPES pps
26: where pps.person_type_id = l_person_type_id;
27:
28: /*
29: ||===========================================================================

Line 155: PER_PERSON_TYPES pps,

151:
152: cursor csr_get_person_type_id(l_person_id Number) is
153: select pps.person_type_id
154: FROM
155: PER_PERSON_TYPES pps,
156: PER_PERSON_TYPE_USAGES_F pptf
157: where pptf.person_id = l_person_id
158: AND pptf.person_type_id = pps.person_type_id
159: AND pps.SYSTEM_PERSON_TYPE = 'EX_EMP';

Line 791: PER_PERSON_TYPES pps,

787:
788: cursor csr_get_person_type_id(l_person_id Number) is
789: select pps.person_type_id
790: FROM
791: PER_PERSON_TYPES pps,
792: PER_PERSON_TYPE_USAGES_F pptf
793: where pptf.person_id = l_person_id
794: AND pptf.person_type_id = pps.person_type_id
795: AND pps.SYSTEM_PERSON_TYPE = 'EX_CWK';