APPS.PAY_RESTRICT_VAL_PKG dependencies on HR_LOOKUPS

Line 68: FROM HR_LOOKUPS HR

64: P_BUSINESS_GROUP_ID NUMBER) IS
65: --
66: CURSOR C_RESTRICTION_TYPE IS
67: SELECT HR.MEANING
68: FROM HR_LOOKUPS HR
69: WHERE HR.LOOKUP_CODE = P_RESTRICTION_CODE
70: AND HR.LOOKUP_TYPE = 'FORM_RESTRICTION_TYPE';
71:
72: CURSOR C_ACTION_TYPE IS

Line 74: FROM HR_LOOKUPS HR

70: AND HR.LOOKUP_TYPE = 'FORM_RESTRICTION_TYPE';
71:
72: CURSOR C_ACTION_TYPE IS
73: SELECT HR.MEANING
74: FROM HR_LOOKUPS HR
75: WHERE HR.LOOKUP_CODE = P_VALUE
76: AND HR.LOOKUP_TYPE = 'ACTION_TYPE';
77:
78: CURSOR C_ELE_SET IS

Line 85: FROM HR_LOOKUPS HR

81: WHERE PES.ELEMENT_SET_ID = P_VALUE;
82:
83: CURSOR C_ELE_TYPE IS
84: SELECT HR.MEANING
85: FROM HR_LOOKUPS HR
86: WHERE HR.LOOKUP_CODE = P_VALUE
87: AND HR.LOOKUP_TYPE = 'PROCESSING_TYPE';
88:
89: CURSOR C_EMP_APL IS

Line 91: FROM HR_LOOKUPS HR

87: AND HR.LOOKUP_TYPE = 'PROCESSING_TYPE';
88:
89: CURSOR C_EMP_APL IS
90: SELECT HR.MEANING
91: FROM HR_LOOKUPS HR
92: WHERE HR.LOOKUP_CODE = P_VALUE
93: AND HR.LOOKUP_TYPE = 'EMP_APL';
94:
95: CURSOR C_ENTRY_TYPE IS

Line 97: FROM HR_LOOKUPS HR

93: AND HR.LOOKUP_TYPE = 'EMP_APL';
94:
95: CURSOR C_ENTRY_TYPE IS
96: SELECT HR.MEANING
97: FROM HR_LOOKUPS HR
98: WHERE HR.LOOKUP_CODE = P_VALUE
99: AND HR.LOOKUP_TYPE = 'ENTRY_TYPE';
100:
101: CURSOR C_ASG_SET IS

Line 103: FROM HR_LOOKUPS HR

99: AND HR.LOOKUP_TYPE = 'ENTRY_TYPE';
100:
101: CURSOR C_ASG_SET IS
102: SELECT HR.MEANING
103: FROM HR_LOOKUPS HR
104: WHERE HR.LOOKUP_CODE = P_VALUE
105: AND HR.LOOKUP_TYPE = 'ASG_SET';
106:
107: CURSOR C_INQUIRY_NAME IS

Line 116: FROM HR_LOOKUPS HR

112: AND REPS.QP_REPORT_ID = P_VALUE;
113:
114: CURSOR C_ORG_CLASS IS
115: SELECT HR.MEANING
116: FROM HR_LOOKUPS HR
117: WHERE HR.LOOKUP_CODE = P_VALUE
118: AND HR.LOOKUP_TYPE = 'ORG_CLASS';
119:
120: CURSOR C_PERSON_FUNCTION IS

Line 122: FROM HR_LOOKUPS HR

118: AND HR.LOOKUP_TYPE = 'ORG_CLASS';
119:
120: CURSOR C_PERSON_FUNCTION IS
121: SELECT HR.MEANING
122: FROM HR_LOOKUPS HR
123: WHERE HR.LOOKUP_CODE = P_VALUE
124: AND HR.LOOKUP_TYPE ='PER_FUNCTION';
125:
126: CURSOR C_SPECIAL_INFO IS

Line 150: FROM HR_LOOKUPS HR

146: AND PPTTL.LANGUAGE = userenv('LANG');
147:
148: CURSOR C_PERSON_ACTION IS
149: SELECT HR.MEANING
150: FROM HR_LOOKUPS HR
151: WHERE HR.LOOKUP_CODE = P_VALUE
152: AND HR.LOOKUP_TYPE ='HR_PTU_ACTION_TYPES';
153:
154: -- Changed the table name from PER_ASSIGNMENT_INFO_TYPES

Line 188: FROM HR_LOOKUPS HR

184: WHERE INFORMATION_TYPE = P_VALUE;
185:
186: CURSOR C_ADV_FIND IS
187: SELECT HR.MEANING
188: FROM HR_LOOKUPS HR
189: WHERE HR.LOOKUP_CODE = P_VALUE
190: AND HR.LOOKUP_TYPE = 'PER_ADV_FIND_ITEMS';
191:
192: CURSOR C_QH_WF_NOTIF IS

Line 201: FROM HR_LOOKUPS HR

197: AND NAME = P_VALUE;
198:
199: CURSOR C_QH_ACTION IS
200: SELECT HR.MEANING
201: FROM HR_LOOKUPS HR
202: WHERE HR.LOOKUP_CODE = P_VALUE
203: AND HR.LOOKUP_TYPE = 'PER_QH_ACTION';
204:
205: CURSOR C_QH_NEW IS

Line 207: FROM HR_LOOKUPS HR

203: AND HR.LOOKUP_TYPE = 'PER_QH_ACTION';
204:
205: CURSOR C_QH_NEW IS
206: SELECT HR.MEANING
207: FROM HR_LOOKUPS HR
208: WHERE HR.LOOKUP_CODE = P_VALUE
209: AND HR.LOOKUP_TYPE = 'PER_QH_NEW';
210:
211: BEGIN