APPS.HR_HELPDESK_UTIL_SS dependencies on PER_ASSIGNMENTS_F

Line 100: select count(*) into ass_sts from per_assignments_f

96: ( assig_id IN per_all_assignments_f.assignment_id%type)
97: RETURN varchar2 is
98: ass_sts number;
99: BEGIN
100: select count(*) into ass_sts from per_assignments_f
101: where assignment_id = assig_id and
102: sysdate between effective_start_date and
103: effective_end_date and
104: primary_flag ='Y';