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.HXC_DEPOSIT_WRAPPER_UTILITIES dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 826: per_assignment_status_types typ

822: cursor c_start_date
823: (p_person_id in NUMBER) is
824: SELECT min(paa.EFFECTIVE_START_DATE)
825: FROM PER_ALL_ASSIGNMENTS_F paa,
826: per_assignment_status_types typ
827: WHERE paa.PERSON_ID = p_person_id
828: AND paa.ASSIGNMENT_TYPE = 'E'
829: AND paa.PRIMARY_FLAG = 'Y'
830: AND paa.ASSIGNMENT_STATUS_TYPE_ID = typ.ASSIGNMENT_STATUS_TYPE_ID

Line 837: per_assignment_status_types typ

833: cursor c_end_date
834: (p_person_id in NUMBER) is
835: SELECT max(paa.EFFECTIVE_END_DATE)
836: FROM PER_ALL_ASSIGNMENTS_F paa,
837: per_assignment_status_types typ
838: WHERE paa.PERSON_ID = p_person_id
839: AND paa.ASSIGNMENT_TYPE = 'E'
840: AND paa.PRIMARY_FLAG = 'Y'
841: AND paa.ASSIGNMENT_STATUS_TYPE_ID = typ.ASSIGNMENT_STATUS_TYPE_ID