DBA Data[Home] [Help]

APPS.HR_GENERAL dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1666: from per_assignment_status_types asg,

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

Line 1667: per_assignment_status_types_tl tl

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');