APPS.AHL_UMP_SMRINSTANCE_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 229: from ahl_unit_deferrals_b, fnd_lookup_values_vl fk

225: cursor get_deferral_sts (p_ue_id in number) IS
226: select decode(unit_deferral_type, 'MEL', 'MEL ' || fk.meaning,
227: 'CDL', 'CDL ' || fk.meaning,
228: fk.meaning) deferral_meaning
229: from ahl_unit_deferrals_b, fnd_lookup_values_vl fk
230: where unit_effectivity_id = p_ue_id
231: and fk.lookup_type = 'AHL_PRD_DF_APPR_STATUS_TYPES'
232: and fk.lookup_code = approval_status_code;
233:

Line 237: from ahl_unit_deferrals_b udf, fnd_lookup_values_vl fk

233:
234: -- get deferral status for open UMP rows.
235: cursor get_open_deferral_sts (p_ue_id in number) IS
236: select fk.meaning defer_meaning
237: from ahl_unit_deferrals_b udf, fnd_lookup_values_vl fk
238: where udf.unit_effectivity_id = p_ue_id
239: and fk.lookup_code = decode(udf.approval_status_code, 'DRAFT',
240: 'DEFERRAL_DRAFT',udf.approval_status_code)
241: and fk.lookup_type = 'AHL_PRD_DF_APPR_STATUS_TYPES'

Line 247: from ahl_unit_deferrals_b udf, fnd_lookup_values_vl fk

243:
244: -- get mel/cdl status for open UMP rows.
245: cursor get_open_mel_cdl_sts (p_ue_id in number) IS
246: select unit_deferral_type || ' ' || fk.meaning defer_meaning
247: from ahl_unit_deferrals_b udf, fnd_lookup_values_vl fk
248: where udf.unit_effectivity_id = p_ue_id
249: and fk.lookup_code = decode(udf.approval_status_code, 'DEFERRED',
250: 'APPROVED',udf.approval_status_code)
251: and fk.lookup_type = 'AHL_PRD_DF_APPR_STATUS_TYPES'