DBA Data[Home] [Help]

APPS.PAY_RESTRICT_VAL_PKG dependencies on PAY_ELEMENT_SETS

Line 80: FROM PAY_ELEMENT_SETS PES

76: AND HR.LOOKUP_TYPE = 'ACTION_TYPE';
77:
78: CURSOR C_ELE_SET IS
79: SELECT PES.ELEMENT_SET_NAME
80: FROM PAY_ELEMENT_SETS PES
81: WHERE PES.ELEMENT_SET_ID = P_VALUE;
82:
83: CURSOR C_ELE_TYPE IS
84: SELECT HR.MEANING

Line 346: FROM PAY_ELEMENT_SETS PES

342: --
343: CURSOR C_ELE_SET IS
344: SELECT PES.ELEMENT_SET_NAME
345: , PES.LEGISLATION_CODE
346: FROM PAY_ELEMENT_SETS PES
347: WHERE PES.ELEMENT_SET_ID = P_VALUE;
348: --
349: CURSOR C_TABLE_NAME IS
350: SELECT PUT.USER_TABLE_NAME

Line 424: FROM PAY_ELEMENT_SETS PES

420: L_VALUE VARCHAR2(80);
421: --
422: CURSOR C_ELE_SET IS
423: SELECT PES.ELEMENT_SET_ID
424: FROM PAY_ELEMENT_SETS PES
425: WHERE PES.ELEMENT_SET_NAME = P_VALUE
426: AND (P_LEG_CODE IS NULL
427: OR (P_LEG_CODE IS NOT NULL
428: AND PES.LEGISLATION_CODE = P_LEG_CODE));