DBA Data[Home] [Help]

APPS.PAY_RESTRICT_VAL_PKG dependencies on PER_PERSON_TYPES_TL

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');