eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ENTRY_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 8074: from per_all_assignments_f paaf,per_assignment_status_types past

8070: end;
8071: --Bug 6809717
8072: --Added to stop deletion of non recurring element entries in case of assignment status change.
8073: select nvl(count(*),0) into l_assign_exist
8074: from per_all_assignments_f paaf,per_assignment_status_types past
8075: where paaf.ASSIGNMENT_ID=p_assignment_id
8076: and p_session_date+1 between paaf.EFFECTIVE_START_DATE and paaf.EFFECTIVE_END_DATE
8077: and paaf.ASSIGNMENT_STATUS_TYPE_ID=past.ASSIGNMENT_STATUS_TYPE_ID
8078: and past.per_system_status='ACTIVE_ASSIGN';