APPS.MTL_CCEOI_ACTION_PUB dependencies on MTL_CYCLE_COUNT_HEADERS

Line 1227: FROM MTL_CYCLE_COUNT_HEADERS

1223: -- Set global variables for container adjustment and discrepancies
1224: SELECT container_enabled_flag, container_adjustment_option, container_discrepancy_option
1225: INTO MTL_CCEOI_VAR_PVT.G_CONTAINER_ENABLED_FLAG, MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION,
1226: MTL_CCEOI_VAR_PVT.G_CONTAINER_DISCREPANCY_OPTION
1227: FROM MTL_CYCLE_COUNT_HEADERS
1228: WHERE cycle_count_header_id = p_interface_rec.cycle_count_header_id;
1229: -- If either flag is null if container enabled flag is enabled (1), set to default.
1230: IF MTL_CCEOI_VAR_PVT.G_CONTAINER_ENABLED_FLAG = 1 THEN
1231: MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION := NVL(MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION, 1);

Line 1284: FROM mtl_cycle_count_headers

1280:
1281: -- Check if Unschedualed Entries are allowed.
1282: SELECT unscheduled_count_entry
1283: INTO l_unsched_allowed
1284: FROM mtl_cycle_count_headers
1285: WHERE cycle_count_header_id = p_interface_rec.cycle_count_header_id;
1286:
1287: -- Loop through table for each item.
1288: v_index := l_expl_tbl.FIRST;