APPS.BEN_MANAGE_CWB_LIFE_EVENTS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1606: per_assignment_status_types ast

1602: --
1603: CURSOR c_manager_id (p_position_id NUMBER) IS
1604: SELECT person_id
1605: FROM per_all_assignments_f ass,
1606: per_assignment_status_types ast
1607: WHERE ass.position_id = p_position_id
1608: AND ass.primary_flag = 'Y'
1609: AND ass.assignment_type IN ('E', 'C') -- Bug 2827121
1610: AND p_effective_date BETWEEN ass.effective_start_date