DBA Data[Home] [Help]

APPS.PER_CANCEL_APPLICATION_API dependencies on PER_ALL_PEOPLE_F

Line 30: from per_all_people_f p,

26: --
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