APPS.PER_CANCEL_APPLICATION_API dependencies on PER_PERSON_TYPES

Line 31: per_person_types pt

27: cursor get_person_type(p_received_date DATE) is
28: select pt.system_person_type,
29: p.effective_start_date
30: from per_all_people_f p,
31: per_person_types pt
32: where p.person_id = p_person_id
33: and p.person_type_id = pt.person_type_id
34: and p_received_date between
35: p.effective_start_date and p.effective_end_date ;

Line 38: l_system_person_type per_person_types.system_person_type%TYPE;

34: and p_received_date between
35: p.effective_start_date and p.effective_end_date ;
36: --
37: l_proc VARCHAR2(72) := g_package||'cancel_application';
38: l_system_person_type per_person_types.system_person_type%TYPE;
39: l_primary_date DATE;
40: l_date_received DATE;
41: l_cancel_type VARCHAR2(10) := 'APL';
42: l_where VARCHAR2(10) := 'BEGIN';