DBA Data[Home] [Help]

APPS.HR_ENTRY_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 8090: from per_all_assignments_f paaf,per_assignment_status_types past

8086: end;
8087: --Bug 6809717
8088: --Added to stop deletion of non recurring element entries in case of assignment status change.
8089: select nvl(count(*),0) into l_assign_exist
8090: from per_all_assignments_f paaf,per_assignment_status_types past
8091: where paaf.ASSIGNMENT_ID=p_assignment_id
8092: and p_session_date+1 between paaf.EFFECTIVE_START_DATE and paaf.EFFECTIVE_END_DATE
8093: and paaf.ASSIGNMENT_STATUS_TYPE_ID=past.ASSIGNMENT_STATUS_TYPE_ID
8094: and past.per_system_status='ACTIVE_ASSIGN';