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.PSP_PSPENEXR_XMLP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 291: PER_ALL_ASSIGNMENTS_F PAAF

287: SELECT
288: ASSIGNMENT_NUMBER,
289: 1 ORDER_BY
290: FROM
291: PER_ALL_ASSIGNMENTS_F PAAF
292: WHERE PAAF.ASSIGNMENT_ID = CF_ASSIGNMENT_NUMBERFORMULA.ASSIGNMENT_ID
293: AND PAAF.EFFECTIVE_START_DATE <= MAX_END_DATE
294: AND PAAF.EFFECTIVE_END_DATE >= MIN_START_DATE
295: AND ROWNUM = 1

Line 301: PER_ALL_ASSIGNMENTS_F PAAF

297: SELECT
298: ASSIGNMENT_NUMBER,
299: 2 ORDER_BY
300: FROM
301: PER_ALL_ASSIGNMENTS_F PAAF
302: WHERE PAAF.ASSIGNMENT_ID = CF_ASSIGNMENT_NUMBERFORMULA.ASSIGNMENT_ID
303: AND PAAF.EFFECTIVE_START_DATE = (
304: SELECT
305: MAX(PAAF2.EFFECTIVE_START_DATE)

Line 307: PER_ALL_ASSIGNMENTS_F PAAF2

303: AND PAAF.EFFECTIVE_START_DATE = (
304: SELECT
305: MAX(PAAF2.EFFECTIVE_START_DATE)
306: FROM
307: PER_ALL_ASSIGNMENTS_F PAAF2
308: WHERE PAAF2.ASSIGNMENT_ID = CF_ASSIGNMENT_NUMBERFORMULA.ASSIGNMENT_ID )
309: ORDER BY
310: 2;
311: L_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE;

Line 311: L_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE;

307: PER_ALL_ASSIGNMENTS_F PAAF2
308: WHERE PAAF2.ASSIGNMENT_ID = CF_ASSIGNMENT_NUMBERFORMULA.ASSIGNMENT_ID )
309: ORDER BY
310: 2;
311: L_ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE;
312: L_DUMMY NUMBER;
313: BEGIN
314: OPEN ASSIGNMENT_CUR;
315: FETCH ASSIGNMENT_CUR