DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PER_ASSIGNMENT_STATUS_TYPES_TL

Line 2596: from per_assignment_status_types_tl typtl,

2592:
2593: -- Can look in per_assignment_status_types now.
2594: select typ.assignment_status_type_id
2595: into l_assignment_status_type_id
2596: from per_assignment_status_types_tl typtl,
2597: per_assignment_status_types typ
2598: where typtl.user_status = p_user_status
2599: and typ.assignment_status_type_id = typtl.assignment_status_type_id
2600: and typtl.LANGUAGE = p_language_code