APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on FND_LOOKUP_VALUES_VL
Line 561: FROM AHL_MC_RELATIONSHIPS MCR, FND_LOOKUP_VALUES_VL ATA
557:
558: -- Cursor to get MC details for the given MC relationship id
559: CURSOR get_mc_details_csr (c_relationship_id NUMBER) IS
560: SELECT ATA.meaning ata_meaning 561: FROM AHL_MC_RELATIONSHIPS MCR, FND_LOOKUP_VALUES_VL ATA 562: WHERE MCR.relationship_id = c_relationship_id
563: AND ATA.lookup_code (+) = MCR.ata_code
564: AND ATA.lookup_type (+) = 'AHL_ATA_CODE';
565: