DBA Data[Home] [Help]

APPS.IGC_CC_COMMON_UTILS_PVT dependencies on FND_LOOKUPS

Line 181: FROM fnd_lookups lkpt

177: -- CC Type
178: BEGIN
179: SELECT lkpt.meaning
180: INTO p_type_desc
181: FROM fnd_lookups lkpt
182: WHERE lkpt.lookup_code = l_header_rec.cc_type
183: AND lkpt.lookup_type = 'IGC_CC_TYPE';
184: EXCEPTION
185: WHEN NO_DATA_FOUND THEN

Line 193: FROM fnd_lookups lkpt

189: -- CC State
190: BEGIN
191: SELECT lkpt.meaning
192: INTO p_state_desc
193: FROM fnd_lookups lkpt
194: WHERE lkpt.lookup_code = l_header_rec.cc_state
195: AND lkpt.lookup_type = 'IGC_CC_STATE';
196: EXCEPTION
197: WHEN NO_DATA_FOUND THEN

Line 205: FROM fnd_lookups lkpt

201: -- CC Apprvl Status
202: BEGIN
203: SELECT lkpt.meaning
204: INTO p_apprvl_status_desc
205: FROM fnd_lookups lkpt
206: WHERE lkpt.lookup_code = l_header_rec.cc_apprvl_status
207: AND lkpt.lookup_type = 'IGC_CC_APPROVAL_STATUS';
208: EXCEPTION
209: WHEN NO_DATA_FOUND THEN

Line 217: FROM fnd_lookups lkpt

213: -- CC Ctrl Status
214: BEGIN
215: SELECT lkpt.meaning
216: INTO p_ctrl_status_desc
217: FROM fnd_lookups lkpt
218: WHERE lkpt.lookup_code = l_header_rec.cc_ctrl_status
219: AND lkpt.lookup_type = 'IGC_CC_CONTROL_STATUS';
220: EXCEPTION
221: WHEN NO_DATA_FOUND THEN