APPS.BEN_MANAGE_CWB_LIFE_EVENTS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1561: per_assignment_status_types ast

1557: --
1558: CURSOR c_manager_id (p_position_id NUMBER) IS
1559: SELECT person_id
1560: FROM per_all_assignments_f ass,
1561: per_assignment_status_types ast
1562: WHERE ass.position_id = p_position_id
1563: AND ass.primary_flag = 'Y'
1564: AND ass.assignment_type IN ('E', 'C') -- Bug 2827121
1565: AND p_effective_date BETWEEN ass.effective_start_date