APPS.HR_HELPDESK_UTIL_SS dependencies on PER_PEOPLE_F

Line 78: select count(*) into per_sts from per_people_f

74: ( person_id IN per_all_people_f.person_id%type)
75: RETURN varchar2 is
76: per_sts number;
77: BEGIN
78: select count(*) into per_sts from per_people_f
79: where person_id = person_id and
80: sysdate between effective_start_date and effective_end_date;
81:
82: if per_sts > 0 then