APPS.HR_HELPDESK_UTIL_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 56: from per_all_assignments_f

52:
53: --pers_id := get_person_id(emp_id,bg_id,cwk_id);
54:
55: select distinct assignment_id into ass_id
56: from per_all_assignments_f
57: where person_id = pers_id
58: and assignment_type in('E','A','C')
59: and sysdate between effective_start_date and
60: effective_end_date and

Line 94: ( assig_id IN per_all_assignments_f.assignment_id%type)

90:
91: end get_person_status;
92:
93: FUNCTION get_assign_status
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