APPS.AHL_ENIGMA_UTIL_PKG dependencies on AHL_UNIT_CONFIG_HEADERS

Line 59: FROM ahl_unit_config_headers uc,ahl_mc_headers_b mc

55: AND rel.mc_header_id = hdr.mc_header_id;
56:
57: CURSOR get_model_and_tail_csr(c_uc_header_id NUMBER) IS
58: SELECT uc.name,model_code
59: FROM ahl_unit_config_headers uc,ahl_mc_headers_b mc
60: WHERE uc.master_config_id = mc.mc_header_id
61: AND unit_config_header_id = c_uc_header_id;
62:
63: CURSOR get_user_and_lang IS

Line 80: ahl_unit_config_headers UCH,

76: SELECT model_code, UCH.name, NVL(TSK.INSTANCE_ID,VST.ITEM_INSTANCE_ID)
77: FROM ahl_workorders AWO,
78: ahl_visits_b VST,
79: ahl_visit_tasks_b TSK,
80: ahl_unit_config_headers UCH,
81: ahl_mc_headers_b MCH
82: WHERE AWO.VISIT_TASK_ID=TSK.VISIT_TASK_ID
83: AND VST.VISIT_ID = TSK.VISIT_ID
84: AND AHL_UTIL_UC_PKG.GET_UC_HEADER_ID(NVL(TSK.INSTANCE_ID,VST.ITEM_INSTANCE_ID)) = UCH.unit_config_header_id