APPS.AHL_PRD_PRINT_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 2022: FROM AHL_UNIT_CONFIG_HEADERS UC ,

2018:
2019: CURSOR get_header_det1_csr (c_uc_id IN NUMBER) IS
2020: SELECT UC.NAME UC_NAME ,
2021: FND1.MEANING MODEL_MEANING
2022: FROM AHL_UNIT_CONFIG_HEADERS UC ,
2023: AHL_MC_HEADERS_B MC ,
2024: FND_LOOKUP_VALUES_VL FND1
2025: WHERE UC.MASTER_CONFIG_ID = MC.MC_HEADER_ID
2026: AND FND1.LOOKUP_CODE(+) = MC.MODEL_CODE

Line 3671: FROM AHL_VISITS_B VST, AHL_UNIT_CONFIG_HEADERS UC

3667: AND visit_id = p_object_id;
3668:
3669: SELECT UC.UNIT_CONFIG_HEADER_ID, UC.NAME, VST.item_instance_id
3670: INTO l_uc_id, l_unit_name, l_count_instance_id
3671: FROM AHL_VISITS_B VST, AHL_UNIT_CONFIG_HEADERS UC
3672: WHERE UC.CSI_ITEM_INSTANCE_ID(+) = VST.ITEM_INSTANCE_ID
3673: AND VST.VISIT_ID = p_object_id;
3674:
3675: EXCEPTION