APPS.GMO_DISP_CON_PKG dependencies on PO_HAZARD_CLASSES

Line 10: FROM PO_HAZARD_CLASSES PHC, MTL_SYSTEM_ITEMS_VL MSI

6: IS
7: l_phc_hazard_class_name VARCHAR2(40);
8: CURSOR C_GET_PHC_CLASS IS
9: SELECT PHC.HAZARD_CLASS
10: FROM PO_HAZARD_CLASSES PHC, MTL_SYSTEM_ITEMS_VL MSI
11: WHERE MSI.INVENTORY_ITEM_ID= P_INVENTORY_ITEM_ID
12: and MSI.ORGANIZATION_ID = P_ORGANIZATION_ID
13: and MSI.HAZARD_CLASS_ID = PHC.HAZARD_CLASS_ID (+)
14: and SYSDATE < (NVL(PHC.INACTIVE_DATE,sysdate));