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.PAY_RESTRICT_VAL_PKG dependencies on PER_PERSON_TYPES

Line 142: FROM PER_PERSON_TYPES_TL PPTTL,

138: WHERE PUT.USER_TABLE_ID = P_VALUE;
139:
140: CURSOR C_PERSON_TYPE IS
141: SELECT PPTTL.USER_PERSON_TYPE
142: FROM PER_PERSON_TYPES_TL PPTTL,
143: PER_PERSON_TYPES PPT
144: WHERE PPT.PERSON_TYPE_ID = P_VALUE
145: AND PPT.PERSON_TYPE_ID = PPTTL.PERSON_TYPE_ID
146: AND PPTTL.LANGUAGE = userenv('LANG');

Line 143: PER_PERSON_TYPES PPT

139:
140: CURSOR C_PERSON_TYPE IS
141: SELECT PPTTL.USER_PERSON_TYPE
142: FROM PER_PERSON_TYPES_TL PPTTL,
143: PER_PERSON_TYPES PPT
144: WHERE PPT.PERSON_TYPE_ID = P_VALUE
145: AND PPT.PERSON_TYPE_ID = PPTTL.PERSON_TYPE_ID
146: AND PPTTL.LANGUAGE = userenv('LANG');
147:

Line 374: FROM PER_PERSON_TYPES PPT

370: AND F.ID_FLEX_CODE = 'PEA';
371: --
372: CURSOR C_PERSON_TYPE IS
373: SELECT PPT.USER_PERSON_TYPE
374: FROM PER_PERSON_TYPES PPT
375: WHERE PPT.PERSON_TYPE_ID = P_VALUE;
376: --
377: BEGIN
378: --

Line 459: FROM PER_PERSON_TYPES PPT

455: AND S.BUSINESS_GROUP_ID IS NULL;
456: --
457: CURSOR C_PERSON_TYPE IS
458: SELECT PPT.PERSON_TYPE_ID
459: FROM PER_PERSON_TYPES PPT
460: WHERE PPT.USER_PERSON_TYPE = P_VALUE
461: AND PPT.BUSINESS_GROUP_ID IS NULL;
462: --
463: BEGIN