2166: AND business_group_id = csr_chk_amends.p_bg_id;
2167: --
2168: CURSOR csr_valid_ast IS
2169: SELECT per_system_status
2170: FROM per_assignment_status_types
2171: WHERE assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id;
2172: --
2173: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
2174: --
2169: SELECT per_system_status
2170: FROM per_assignment_status_types
2171: WHERE assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id;
2172: --
2173: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
2174: --
2175: -- 120.10 (END)
2176: --
2177: --
4970: --
4971: cursor csr_chk_term_status is
4972: select null
4973: from per_all_assignments_f pas
4974: , per_assignment_status_types past
4975: where pas.assignment_id = p_assignment_id
4976: and pas.effective_start_date >= p_validation_start_date
4977: and past.assignment_status_type_id = pas.assignment_status_type_id
4978: and past.per_system_status = 'TERM_ASSIGN';