APPS.PAY_RESTRICT_VAL_PKG dependencies on PAY_USER_TABLES

Line 137: FROM PAY_USER_TABLES PUT

133: AND F.ID_FLEX_CODE = 'PEA';
134:
135: CURSOR C_TABLE_NAME IS
136: SELECT PUT.USER_TABLE_NAME
137: FROM PAY_USER_TABLES PUT
138: WHERE PUT.USER_TABLE_ID = P_VALUE;
139:
140: CURSOR C_PERSON_TYPE IS
141: SELECT PPTTL.USER_PERSON_TYPE

Line 352: FROM PAY_USER_TABLES PUT

348: --
349: CURSOR C_TABLE_NAME IS
350: SELECT PUT.USER_TABLE_NAME
351: , PUT.LEGISLATION_CODE
352: FROM PAY_USER_TABLES PUT
353: WHERE PUT.USER_TABLE_ID = P_VALUE;
354: --
355: CURSOR C_INQUIRY_NAME IS
356: SELECT REPS.QP_REPORT_NAME

Line 432: FROM PAY_USER_TABLES PUT

428: AND PES.LEGISLATION_CODE = P_LEG_CODE));
429: --
430: CURSOR C_TABLE_NAME IS
431: SELECT PUT.USER_TABLE_ID
432: FROM PAY_USER_TABLES PUT
433: WHERE PUT.USER_TABLE_NAME = P_VALUE
434: AND (P_LEG_CODE IS NULL
435: OR (P_LEG_CODE IS NOT NULL
436: AND PUT.LEGISLATION_CODE = P_LEG_CODE));