DBA Data[Home] [Help]

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;