APPS.OTA_UTILITY dependencies on PER_PERSON_TYPES

Line 2692: per_person_types ppt

2688: cursor get_person_type is
2689: SELECT ppt.system_person_type
2690: FROM per_all_people_f per,
2691: per_person_type_usages_f ptu,
2692: per_person_types ppt
2693: WHERE
2694: per.person_id = p_person_id
2695: AND ptu.person_id = per.person_id
2696: AND ppt.business_group_id = per.business_group_id

Line 2703: l_system_person_type per_person_types.system_person_type%TYPE;

2699: AND trunc(sysdate) between ptu.effective_start_date AND ptu.effective_end_date
2700: AND ppt.system_person_type <> 'APL'
2701: AND ppt.system_person_type in ('EMP','CWK');
2702:
2703: l_system_person_type per_person_types.system_person_type%TYPE;
2704:
2705: Begin
2706: Open get_person_type;
2707: Fetch get_person_type into l_system_person_type;