DBA Data[Home] [Help]

APPS.HR_HELPDESK_UTIL_SS dependencies on PER_PEOPLE_F

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

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