APPS.PER_PERRPCTM_XMLP_PKG dependencies on HR_LOOKUPS

Line 84: HR_LOOKUPS

80: MEANING
81: INTO
82: V_LEAV_REASON1
83: FROM
84: HR_LOOKUPS
85: WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
86: AND LOOKUP_CODE = P_LEAV_REASON1;
87: C_LEAV_REASON1 := V_LEAV_REASON1;
88: C_HEAD_REASONS := V_LEAV_REASON1;

Line 96: HR_LOOKUPS

92: MEANING
93: INTO
94: V_LEAV_REASON2
95: FROM
96: HR_LOOKUPS
97: WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
98: AND LOOKUP_CODE = P_LEAV_REASON2;
99: C_LEAV_REASON2 := V_LEAV_REASON2;
100: C_HEAD_REASONS := C_HEAD_REASONS || ',' || V_LEAV_REASON2;

Line 108: HR_LOOKUPS

104: MEANING
105: INTO
106: V_LEAV_REASON3
107: FROM
108: HR_LOOKUPS
109: WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
110: AND LOOKUP_CODE = P_LEAV_REASON3;
111: C_LEAV_REASON3 := V_LEAV_REASON3;
112: C_HEAD_REASONS := C_HEAD_REASONS || ',' || V_LEAV_REASON3;

Line 120: HR_LOOKUPS

116: MEANING
117: INTO
118: V_LEAV_REASON4
119: FROM
120: HR_LOOKUPS
121: WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
122: AND LOOKUP_CODE = P_LEAV_REASON4;
123: C_LEAV_REASON4 := V_LEAV_REASON4;
124: C_HEAD_REASONS := C_HEAD_REASONS || ',' || V_LEAV_REASON4;

Line 132: HR_LOOKUPS

128: MEANING
129: INTO
130: V_LEAV_REASON5
131: FROM
132: HR_LOOKUPS
133: WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
134: AND LOOKUP_CODE = P_LEAV_REASON5;
135: C_LEAV_REASON5 := V_LEAV_REASON5;
136: C_HEAD_REASONS := C_HEAD_REASONS || ',' || V_LEAV_REASON5;

Line 144: HR_LOOKUPS

140: MEANING
141: INTO
142: V_LEAV_REASON6
143: FROM
144: HR_LOOKUPS
145: WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
146: AND LOOKUP_CODE = P_LEAV_REASON6;
147: C_LEAV_REASON6 := V_LEAV_REASON6;
148: C_HEAD_REASONS := C_HEAD_REASONS || ',' || V_LEAV_REASON6;