APPS.HR_HELPDESK_UTIL_SS dependencies on PER_ASSIGNMENTS_F

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

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