1662: and tl.language=USERENV('LANG');
1663: --
1664: cursor csr_assign_user_status is
1665: select tl.user_status
1666: from per_assignment_status_types asg,
1667: per_assignment_status_types_tl tl
1668: where asg.assignment_status_type_id = p_assignment_status_type_id
1669: and asg.assignment_status_type_id =
1670: tl.assignment_status_type_id
1663: --
1664: cursor csr_assign_user_status is
1665: select tl.user_status
1666: from per_assignment_status_types asg,
1667: per_assignment_status_types_tl tl
1668: where asg.assignment_status_type_id = p_assignment_status_type_id
1669: and asg.assignment_status_type_id =
1670: tl.assignment_status_type_id
1671: and tl.language=USERENV('LANG');