APPS.PER_PERRPRTM_XMLP_PKG dependencies on HR_LOOKUPS

Line 116: HR_LOOKUPS

112: ,30),
113: MEANING
114: INTO V_LEAV_REASON1,V_LEAV_RDESC1
115: FROM
116: HR_LOOKUPS
117: WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
118: AND LOOKUP_CODE = P_LEAV_REASON1;
119: C_LEAV_REASON1 := V_LEAV_REASON1;
120: C_HEAD_REASONS := V_LEAV_RDESC1;

Line 130: HR_LOOKUPS

126: ,30),
127: MEANING
128: INTO V_LEAV_REASON2,V_LEAV_RDESC2
129: FROM
130: HR_LOOKUPS
131: WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
132: AND LOOKUP_CODE = P_LEAV_REASON2;
133: C_LEAV_REASON2 := V_LEAV_REASON2;
134: C_HEAD_REASONS := C_HEAD_REASONS || ',' || V_LEAV_RDESC2;

Line 144: HR_LOOKUPS

140: ,30),
141: MEANING
142: INTO V_LEAV_REASON3,V_LEAV_RDESC3
143: FROM
144: HR_LOOKUPS
145: WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
146: AND LOOKUP_CODE = P_LEAV_REASON3;
147: C_LEAV_REASON3 := V_LEAV_REASON3;
148: C_HEAD_REASONS := C_HEAD_REASONS || ',' || V_LEAV_RDESC3;

Line 158: HR_LOOKUPS

154: ,30),
155: MEANING
156: INTO V_LEAV_REASON4,V_LEAV_RDESC4
157: FROM
158: HR_LOOKUPS
159: WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
160: AND LOOKUP_CODE = P_LEAV_REASON4;
161: C_LEAV_REASON4 := V_LEAV_REASON4;
162: C_HEAD_REASONS := C_HEAD_REASONS || ',' || V_LEAV_RDESC4;

Line 172: HR_LOOKUPS

168: ,30),
169: MEANING
170: INTO V_LEAV_REASON5,V_LEAV_RDESC5
171: FROM
172: HR_LOOKUPS
173: WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
174: AND LOOKUP_CODE = P_LEAV_REASON5;
175: C_LEAV_REASON5 := V_LEAV_REASON5;
176: C_HEAD_REASONS := C_HEAD_REASONS || ',' || V_LEAV_RDESC5;

Line 186: HR_LOOKUPS

182: ,30),
183: MEANING
184: INTO V_LEAV_REASON6,V_LEAV_RDESC6
185: FROM
186: HR_LOOKUPS
187: WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
188: AND LOOKUP_CODE = P_LEAV_REASON6;
189: C_LEAV_REASON6 := V_LEAV_REASON6;
190: C_HEAD_REASONS := C_HEAD_REASONS || ',' || V_LEAV_RDESC6;