APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 1082: SELECT csi_item_instance_id FROM AHL_UNIT_EFFECTIVITIES_B

1078:
1079: -- Begin changes by rnahata for Issue 105
1080: --Cursor to fetch the instance id when effectivity is given
1081: CURSOR c_get_prev_instance_id (p_unit_effectivity IN NUMBER) IS
1082: SELECT csi_item_instance_id FROM AHL_UNIT_EFFECTIVITIES_B
1083: WHERE UNIT_EFFECTIVITY_ID = p_unit_effectivity;
1084:
1085: --Cursor to fetch instance quantity
1086: CURSOR c_get_instance_qty(p_unit_effectivity IN NUMBER) IS

Line 1088: FROM csi_item_instances csii, ahl_unit_effectivities_b ue

1084:
1085: --Cursor to fetch instance quantity
1086: CURSOR c_get_instance_qty(p_unit_effectivity IN NUMBER) IS
1087: SELECT csii.quantity, ue.csi_item_instance_id
1088: FROM csi_item_instances csii, ahl_unit_effectivities_b ue
1089: WHERE ue.unit_effectivity_id = p_unit_effectivity
1090: AND csii.instance_id = ue.csi_item_instance_id;
1091:
1092: l_instance_qty NUMBER := 0;