2562: when others then
2563: raise;
2564: end;
2565:
2566: -- Can look in per_assignment_status_types now.
2567: select typ.assignment_status_type_id
2568: into l_assignment_status_type_id
2569: from per_assignment_status_types_tl typtl,
2570: per_assignment_status_types typ
2565:
2566: -- Can look in per_assignment_status_types now.
2567: select typ.assignment_status_type_id
2568: into l_assignment_status_type_id
2569: from per_assignment_status_types_tl typtl,
2570: per_assignment_status_types typ
2571: where typtl.user_status = p_user_status
2572: and typ.assignment_status_type_id = typtl.assignment_status_type_id
2573: and typtl.LANGUAGE = p_language_code
2566: -- Can look in per_assignment_status_types now.
2567: select typ.assignment_status_type_id
2568: into l_assignment_status_type_id
2569: from per_assignment_status_types_tl typtl,
2570: per_assignment_status_types typ
2571: where typtl.user_status = p_user_status
2572: and typ.assignment_status_type_id = typtl.assignment_status_type_id
2573: and typtl.LANGUAGE = p_language_code
2574: and