APPS.AHL_ENIGMA_IPC_PROCS_PVT dependencies on AHL_ITEM_ASSOCIATIONS_B

Line 177: FROM ahl_item_associations_b

173: AND TRUNC(NVL(end_date_active, SYSDATE - 1)) < TRUNC(SYSDATE);
174:
175: CURSOR get_ia_id_csr (p_ig_id NUMBER, p_item_id NUMBER, p_item_revision VARCHAR2, p_org_id NUMBER) IS
176: SELECT item_association_id
177: FROM ahl_item_associations_b
178: WHERE item_group_id = p_ig_id
179: AND inventory_item_id = p_item_id
180: AND NVL(revision, '-') = NVL(p_item_revision, '-')
181: AND inventory_org_id = p_org_id;