DBA Data[Home] [Help]

APPS.HR_GENERAL dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1668: from per_assignment_status_types asg,

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

Line 1669: per_assignment_status_types_tl tl

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