APPS.HR_HELPDESK_UTIL_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 57: from per_all_assignments_f

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

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

92:
93: END get_person_status;
94:
95: FUNCTION get_assign_status
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