APPS.WIP_BIS_COMMON dependencies on PER_ALL_ASSIGNMENTS_F
Line 36: from per_all_assignments_f
32: return NUMBER is
33:
34: Cursor Employee_Num(p_date DATE, p_organization_id NUMBER) is
35: select count(assignment_id) 36: from per_all_assignments_f 37: where primary_flag = 'Y'
38: and assignment_type = 'E'
39: and trunc(p_date) between effective_start_date and effective_end_date
40: and organization_id = p_organization_id;