[Home] [Help]
248: -- 923011: Ensure user status is in the appropriate language
249: cursor def_assgt_status is
250: select nvl(btl.user_status,atl.user_status),
251: a.assignment_status_type_id
252: from per_assignment_status_types_tl atl,
253: per_assignment_status_types a,
254: per_ass_status_type_amends_tl btl,
255: per_ass_status_type_amends b
256: where atl.assignment_status_type_id = a.assignment_status_type_id