6765: --
6766: cursor c_assignment_status_type_name is
6767: select nvl(atl.user_status,stl.user_status) user_status
6768: from per_assignment_status_types s,
6769: per_ass_status_type_amends a ,
6770: per_assignment_status_types_tl stl,
6771: per_ass_status_type_amends_tl atl
6772: where s.assignment_status_type_id = p_assignment_status_type_id
6773: and a.assignment_status_type_id (+) = s.assignment_status_type_id
6767: select nvl(atl.user_status,stl.user_status) user_status
6768: from per_assignment_status_types s,
6769: per_ass_status_type_amends a ,
6770: per_assignment_status_types_tl stl,
6771: per_ass_status_type_amends_tl atl
6772: where s.assignment_status_type_id = p_assignment_status_type_id
6773: and a.assignment_status_type_id (+) = s.assignment_status_type_id
6774: and s.active_flag = 'Y'
6775: and a.active_flag(+) = 'Y'