DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 2566: -- Can look in per_assignment_status_types now.

2562: when others then
2563: raise;
2564: end;
2565:
2566: -- Can look in per_assignment_status_types now.
2567: select typ.assignment_status_type_id
2568: into l_assignment_status_type_id
2569: from per_assignment_status_types_tl typtl,
2570: per_assignment_status_types typ

Line 2569: from per_assignment_status_types_tl typtl,

2565:
2566: -- Can look in per_assignment_status_types now.
2567: select typ.assignment_status_type_id
2568: into l_assignment_status_type_id
2569: from per_assignment_status_types_tl typtl,
2570: per_assignment_status_types typ
2571: where typtl.user_status = p_user_status
2572: and typ.assignment_status_type_id = typtl.assignment_status_type_id
2573: and typtl.LANGUAGE = p_language_code

Line 2570: per_assignment_status_types typ

2566: -- Can look in per_assignment_status_types now.
2567: select typ.assignment_status_type_id
2568: into l_assignment_status_type_id
2569: from per_assignment_status_types_tl typtl,
2570: per_assignment_status_types typ
2571: where typtl.user_status = p_user_status
2572: and typ.assignment_status_type_id = typtl.assignment_status_type_id
2573: and typtl.LANGUAGE = p_language_code
2574: and