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

Line 186: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720

182: SELECT
183: MAX(ASS1.EFFECTIVE_START_DATE)
184: FROM
185: PER_ASSIGNMENTS_F ASS1,
186: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720
187: WHERE L_DATE_START <= ASS1.EFFECTIVE_END_DATE
188: AND L_DATE_END >= ASS1.EFFECTIVE_START_DATE
189: AND ASS.PERSON_ID = ASS1.PERSON_ID
190: AND ASS1.ASSIGNMENT_TYPE = 'E'

Line 328: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720

324: SELECT
325: MAX(ASS1.EFFECTIVE_START_DATE)
326: FROM
327: PER_ASSIGNMENTS_F ASS1,
328: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720
329: WHERE L_DATE_START <= ASS1.EFFECTIVE_END_DATE
330: AND L_DATE_END >= ASS1.EFFECTIVE_START_DATE
331: AND ASS.PERSON_ID = ASS1.PERSON_ID
332: AND ASS1.ASSIGNMENT_TYPE = 'E'

Line 467: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720

463: SELECT
464: MAX(ASS1.EFFECTIVE_START_DATE)
465: FROM
466: PER_ASSIGNMENTS_F ASS1,
467: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720
468: WHERE L_DATE_START <= ASS1.EFFECTIVE_END_DATE
469: AND L_DATE_END >= ASS1.EFFECTIVE_START_DATE
470: AND ASS.PERSON_ID = ASS1.PERSON_ID
471: AND ASS1.ASSIGNMENT_TYPE = 'E'