APPS.AHL_UMP_SMRINSTANCE_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 240: from ahl_unit_deferrals_b, fnd_lookup_values_vl fk

236: cursor get_deferral_sts (p_ue_id in number) IS
237: select decode(unit_deferral_type, 'MEL', 'MEL ' || fk.meaning,
238: 'CDL', 'CDL ' || fk.meaning,
239: fk.meaning) deferral_meaning
240: from ahl_unit_deferrals_b, fnd_lookup_values_vl fk
241: where unit_effectivity_id = p_ue_id
242: and fk.lookup_type = 'AHL_PRD_DF_APPR_STATUS_TYPES'
243: and fk.lookup_code = approval_status_code;
244:

Line 248: from ahl_unit_deferrals_b udf, fnd_lookup_values_vl fk

244:
245: -- get deferral status for open UMP rows.
246: cursor get_open_deferral_sts (p_ue_id in number) IS
247: select fk.meaning defer_meaning
248: from ahl_unit_deferrals_b udf, fnd_lookup_values_vl fk
249: where udf.unit_effectivity_id = p_ue_id
250: and fk.lookup_code = decode(udf.approval_status_code,
251: 'DEFERRAL_PENDING', DECODE(NVL(udf.cancel_flag,'N'),'Y','CANCEL_PENDING','DEFERRAL_PENDING'),
252: 'DEFERRAL_REJECTED', DECODE(NVL(udf.cancel_flag,'N'),'Y','CANCEL_REJECTED','DEFERRAL_REJECTED'),

Line 261: from ahl_unit_deferrals_b udf, fnd_lookup_values_vl fk

257:
258: -- get mel/cdl status for open UMP rows.
259: cursor get_open_mel_cdl_sts (p_ue_id in number) IS
260: select unit_deferral_type || ' ' || fk.meaning defer_meaning
261: from ahl_unit_deferrals_b udf, fnd_lookup_values_vl fk
262: where udf.unit_effectivity_id = p_ue_id
263: and fk.lookup_code = decode(udf.approval_status_code, 'DEFERRED',
264: 'APPROVED',udf.approval_status_code)
265: and fk.lookup_type = 'AHL_PRD_DF_APPR_STATUS_TYPES'