APPS.AHL_ENIGMA_IPC_PROCS_PVT dependencies on AHL_ITEM_GROUPS_B

Line 150: FROM ahl_item_groups_b

146: ) IS
147:
148: CURSOR get_ig_id_csr (p_ig_name VARCHAR2) IS
149: SELECT item_group_id
150: FROM ahl_item_groups_b
151: WHERE name = NVL(p_ig_name, '-')
152: AND status_code <> 'REMOVED'
153: AND NVL(sourced_from_enigma_flag, 'N') = 'Y';
154:

Line 450: -- update the new field SOURCED_FROM_ENIGMA_FLAG in the table AHL_ITEM_GROUPS_B

446: END IF;
447: RAISE FND_API.G_EXC_ERROR;
448: END IF;
449:
450: -- update the new field SOURCED_FROM_ENIGMA_FLAG in the table AHL_ITEM_GROUPS_B
451: UPDATE ahl_item_groups_b
452: SET sourced_from_enigma_flag = 'Y'
453: WHERE item_group_id = l_item_group_rec.item_group_id;
454:

Line 451: UPDATE ahl_item_groups_b

447: RAISE FND_API.G_EXC_ERROR;
448: END IF;
449:
450: -- update the new field SOURCED_FROM_ENIGMA_FLAG in the table AHL_ITEM_GROUPS_B
451: UPDATE ahl_item_groups_b
452: SET sourced_from_enigma_flag = 'Y'
453: WHERE item_group_id = l_item_group_rec.item_group_id;
454:
455: ELSIF (l_item_group_rec.operation_flag = 'M') THEN

Line 688: FROM ahl_item_groups_b

684: AND TRUNC(NVL(end_date_active, SYSDATE - 1)) < TRUNC(SYSDATE);
685:
686: CURSOR get_ig_id_csr (p_ig_name VARCHAR2) IS
687: SELECT item_group_id
688: FROM ahl_item_groups_b
689: WHERE name = NVL(p_ig_name, '-')
690: AND status_code <> 'REMOVED'
691: AND NVL(sourced_from_enigma_flag, 'N') = 'Y';
692: