DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 2593: -- Can look in per_assignment_status_types now.

2589: when others then
2590: raise;
2591: end;
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

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

Line 2597: per_assignment_status_types typ

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
2601: and