234: nvl(a.per_system_status ,s.per_system_status)
235: FROM
236: per_ass_status_type_amends_tl atl,
237: per_ass_status_type_amends a,
238: per_assignment_status_types_tl stl,
239: per_assignment_status_types s
240: WHERE
241: s.assignment_status_type_id= p_assignment_status_type_id and
242: a.assignment_status_type_id (+) = s.assignment_status_type_id and
235: FROM
236: per_ass_status_type_amends_tl atl,
237: per_ass_status_type_amends a,
238: per_assignment_status_types_tl stl,
239: per_assignment_status_types s
240: WHERE
241: s.assignment_status_type_id= p_assignment_status_type_id and
242: a.assignment_status_type_id (+) = s.assignment_status_type_id and
243: a.business_group_id (+) +0= p_business_group_id and